This script will DELETE ALL constraints within the database that you define and in the following order: Foreign Key, Primary Key and then Unique Key.
CAUTION:This script does not print out the ALTER TABLE statements, it drop the constraints immediately, therefore backup your database before testing or using this script.
I ran the script below and it deleted 591 constraints in about 2 minutes.
I created and tested this script on SQL Server 2005, I don't know if it will work on SQL 2000
2007-10-02 (first published: 2002-06-20)
15,455 reads