Remove all constraints in a database

Hi Everyone..

I want to remove all the constraints from all the tables in a database. I'm using SQL Server 2000.

will you please help me.. Thanks in advance

with regards

Fraijo

Select the database in the object explorer of SQL Server Enterprise Manager, right click, select Tasks and then Generate Scripts. Generate a script with all tables specified. Get the constraint drops from within that script.

I am curious as to why you wish to do this.