TABLE_CONSTRAINTS
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. |
