SQLTeam.com | Weblogs | Forums

Foreign Key Drop and Recreation


#1

As part of my requirement i need to drop all foreign constraints and then truncate all table's date and recreate the same foreign keys again. is there any way to get the definition of all foreign key constraints to get recreate?


#2

Please see this : https://www.mssqltips.com/sqlservertip/3347/drop-and-recreate-all-foreign-key-constraints-in-sql-server/


#3

Thanks Mangal.