Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Reorder Primary Key - any problem?

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@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 - 08:29:57 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US