Hi, I am new to database. I want to know, in which table all constraints info. is stored in SQl Server like in Oracle it is stored in USER_CONSTRAINTS & USER_CONS_COLUMNS View. What is the sql server way to know it ?
views:
27answers:
2
+1
A:
look first at the information schema views:
INFORMATION_SCHEMA.TABLE_CONSTRAINTS
is probably the one you want but there are a couple of others that might hellp you get information you want.
HLGEM
2010-09-27 13:28:26
+1
A:
Phil Factor recently wrote up a lot of examples:Exploring foreign key relationships with system views
AlexKuznetsov
2010-09-27 13:41:32