Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table dropped, but constraint and index not
Message
From
26/02/2009 06:51:51
Naomi Nosonovsky
Wisconsin, United States
 
 
To
26/02/2009 01:13:03
John Jones
Kuala Lumpur, Malaysia
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: Table dropped, but constraint and index not
Environment versions
SQL Server:
SQL Server 2005
Application:
Web
Miscellaneous
Thread ID:
01384235
Message ID:
01384252
Views:
32
>Hi,
>I have problem that, my table in SQL Server is accidently dropped, however, its index and constraint still exist. It caused I am not able to recreate the table. How could I clean it up?
>
>Thank you

Can you run ALTER TABLE command with DROP CONSTRAINT clause ? And DROP INDEX command?

See also http://www.mssqltips.com/category.asp?catid=76

and in particular

http://www.mssqltips.com/tip.asp?tip=1119
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform