sys.column_type_usages

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.

See Also

Reference

Scalar Types Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)

Other Resources

Implementing User-defined Types
Querying the SQL Server System Catalog FAQ

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release	History
14 April 2006	New content: In the description for user_type_id, added information about how to return the name of the type.