I have a production SQL Server (2000) that includes quite a few tables that
include FKs pointing to various other tables. Those FKs are defined with
referential integrity enabled. For example, I have a master "Names" table
which has information on individuals. I have another table "Suppliers" that
includes an FK field ("Contact") pointing to an entry in the "Names" table.

I've been testing a new structure on a different SQL Server and many tables
have had fields add, renamed, re-sized, etc. I want to replace the tables on
the production system with the new versions. I was going to simply delete
all the tables that will be changed from the production server and then use
DTS to transfer the new versions. The problem is that any table that has the
data linked to by the FKs in other tables cannot be deleted.

How can I accomplish this.

Wayne

In message <OuB4$nUeEHA.3476 (AT) tk2msftngp13 (DOT) phx.gbl>, Wayne Wengert
<wayneDONTWANTSPAM (AT) wengert (DOT) com> writes
Script off the constraints, as drops and creates. Run drops, do the DTS
stuff, run the create script. Probably a clever way of doing if you
don't have them, but we always have scripts created to do the job as it
is how we do change control and such like.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org