sys.column_type_usages (Transact-SQL)
Applies to: SQL Server
Contains one row for each column that is of user-defined type.
Column name | Data type | Description |
---|---|---|
object_id | int | ID of the object to which this column belongs. |
column_id | int | ID of the column. Is unique within the object. |
user_type_id | int | ID of the user-defined type. To return the name of the type, join to the sys.types catalog view on this column. |
Permissions
Requires membership in the public role. For more information, see Metadata Visibility Configuration.
See Also
Scalar Types Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
Querying the SQL Server System Catalog FAQ