>>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.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
