Viewing 3 posts - 1 through 3 (of 3 total)
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]
--...
April 12, 2006 at 6:09 pm
#632260
The results I get in my SQL Server 2005 are as per Sushilas finding. But not in SQL Server 2000 (v8.00.194)
April 3, 2006 at 9:17 pm
#630563
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...
October 12, 2005 at 11:04 pm
#597006