Hi,

I want to delete one table , before deleting that i want to store the Constraint names whatever the table have.

How to get the Constraint names(primary,foreign,Unique,Check,Default) from any table in sqlserver 2000.


Any leads on the best way to accomplish this task would be most appreciated.



Regards,
Sumanth






Confidentiality Notice

The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [Email address protected] immediately
and destroy all copies of this message and any attachments.

MS Sql Server LazyDBA home page