TABLE_CONSTRAINTS

Transact-SQL Reference

Transact-SQL Reference

TABLE_CONSTRAINTS

Contains one row for each table constraint in the current database. This information schema view returns information about the objects to which the current user has permissions. The INFORMATION_SCHEMA.TABLE_CONSTRAINTS view is based on the sysobjects system table.

To retrieve information from these views, specify the fully qualified name of INFORMATION_SCHEMA view_name.

Column name Data type Description
CONSTRAINT_CATALOG nvarchar(128) Constraint qualifier.
CONSTRAINT_SCHEMA nvarchar(128) Constraint owner.
CONSTRAINT_NAME sysname Constraint name.
TABLE_CATALOG nvarchar(128) Table qualifier.
TABLE_SCHEMA nvarchar(128) Table owner.
TABLE_NAME sysname Table name.
CONSTRAINT_TYPE varchar(11) Type of constraint. Can be CHECK, UNIQUE, PRIMARY KEY, or FOREIGN KEY.
IS_DEFERRABLE varchar(2) Specifies whether constraint checking is deferrable. Always returns NO.
INITIALLY_DEFERRED varchar(2) Specifies whether constraint checking is initially deferred. Always returns NO.

See Also

sysobjects