On Thu, 23 May 2002 09:46:02 -0500, Sami Aaron wrote:

>  Here's how I
>would do a major re-work on the order of columns in a table.

Step 3.5:  Make a note of and Drop all the FK's from other tables that 
refer to the PK of the original table.  (Use FindFKs.rmd, attached to this 
message.)

Step 6.5: Recreate the FK's on those other tables, referencing the new 
version of the table.

Bill





Attachment: findfks.rmd
Description: Binary data

Reply via email to