Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to see/report of all table constraints?
Message
From
27/04/2010 19:02:48
Naomi Nosonovsky
Wisconsin, United States
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: How to see/report of all table constraints?
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01462283
Message ID:
01462284
Views:
45
>Hi,
>
>How do you create a report or view on the screen all constraints for a table in a database?
>
>TIA.

Check select * from information_schema.CONSTRAINT_COLUMN_USAGE

See also

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/missing-foreign-key-constraints

Or if you want to see all the code, you can just get a create table script by right-clicking the table in SSMS.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform