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 user-defined data type. This information schema view returns information about the objects to which the current user has permissions. The INFORMATION_SCHEMA.COLUMN_DOMAIN_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
DOMAIN_CATALOG nvarchar(128) Database in which the user-defined data type exists.
DOMAIN_SCHEMA nvarchar(128) Username that created the user-defined data type.
DOMAIN_NAME sysname User-defined data type.
TABLE_CATALOG nvarchar(128) Table qualifier.
TABLE_SCHEMA nvarchar(128) Table owner.
TABLE_NAME sysname Table in which the user-defined data type is used.
COLUMN_NAME sysname Column using the user-defined data type.

See Also




© 2015 Microsoft