renaming multiple tables and retain foreign keys

#1 (**permalink**) 03-28-2008, 04:40 AM

I have 3 tables with foreign keys limited to the that group of
tables.
I need to create temp tables with new data create the foreign keys
and then replace the current tables with the new tables.
how can I do this with retaining the foreign keys

thanks for the help

john

#2 (**permalink**) 03-28-2008, 04:40 AM

Coltrane wrote:
>I have 3 tables with foreign keys limited to the that group of
> tables.
> I need to create temp tables with new data create the foreign keys
> and then replace the current tables with the new tables.
> how can I do this with retaining the foreign keys
>
> thanks for the help
>
> john

Can you try re-writing this with some punctuation? As it stands I can't
figure out what it is supposed to mean.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode