Re: Reorder Primary Key - any problem?
From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 2 Sep 2004 09:29:57 -0400
Message-ID: <T9qdnSNcWpfHvarcRVn-tA_at_comcast.com>
Date: Thu, 2 Sep 2004 09:29:57 -0400
Message-ID: <T9qdnSNcWpfHvarcRVn-tA_at_comcast.com>
"t53864" <t53864_at_yahoo.com> wrote in message
news:9e76ab37.0409020505.501f06d7_at_posting.google.com...
| I need to reorder the primary key of a table. Say,
|
| Primary Key (field1, field2)
|
| changed to:
|
| Primary Key (field2, field1)
|
| Would like to know if this creates any problem to the
| database?
sort of -- all FKs would be dropped when the PK is dropped, and then recreated with the new column order explicitly indicated
do a little testing to see the effects
++ mcs Received on Thu Sep 02 2004 - 15:29:57 CEST