Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining


SQL Server 2000

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


© 2015 Microsoft