when you drop constraints in the database, you need to drop them in order, foreign key constraints first, then others. Here is the script, assumes tables are owned by [dbo]

--...

The results I get in my SQL Server 2005 are as per Sushilas finding. But not in SQL Server 2000 (v8.00.194)

Thanks Carl for the reply. But still does not work.

Here is a my test in SQL Server 2000 Query Analyser

-- Warning !!!, dropping a table

Drop Table T1

Create Table T1 (C1...