sys.table_types
compatibility #compatibility#catalog-view
Description
Displays properties of user-defined table types in SQL Server. A table type is a type from which table variables or table-valued parameters could be declared. Each table type has a that is a foreign key into the catalog view. You can use this ID column to query various catalog views, in a way that is similar to an regular table, to discover the structure of the table type such as its columns and constraints.