Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All


SQL Server 2000

Contains one row for each column, in the current database, that has a constraint defined on it. This information schema view returns information about the objects to which the current user has permissions. The INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE view is based on the sysobjects, syscolumns, and systypes system tables.

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

Column name Data type Description
TABLE_CATALOG nvarchar(128) Table qualifier
TABLE_SCHEMA nvarchar(128) Table owner
TABLE_NAME nvarchar(128) Table name
COLUMN_NAME nvarchar(128) Column name
CONSTRAINT_CATALOG nvarchar(128) Constraint qualifier
CONSTRAINT_SCHEMA nvarchar(128) Constraint owner
CONSTRAINT_NAME nvarchar(128) Constraint name

See Also




© 2015 Microsoft