All geek questions in one place

Which table stores constraint information in SQL Server 2008?

I am new to databases. I want to know which table stores all the information about the limitations of SQL Server, such representation USER_CONSTRAINTSand USER_CONS_COLUMNSin Oracle.

How to find restrictions for SQL Server?

+3
source share
2 answers

First look at the views of the information diagram:

INFORMATION_SCHEMA.TABLE_CONSTRAINTS

probably the one you want, but there are a few others that could get the information you want.

+2
source

Phil Factor recently wrote many examples: Exploring Foreign Key Relationships with System Views

+1
source

Source: https://habr.com/ru/post/1766768/

More articles:


All Articles