Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table dropped, but constraint and index not
Message
 
 
À
26/02/2009 01:13:03
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2005
Application:
Web
Divers
Thread ID:
01384235
Message ID:
01384252
Vues:
31
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform