XPost: comp.databases.oracle.server   
   From: mcstockX@Xenquery   
      
   "t53864"  wrote in message   
   news:9e76ab37.0409020505.501f06d7@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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)