sys.table_types (Transact-SQL)
Displays properties of user-defined table types. A table type is a type from which table variables or table-valued parameters could be declared. Each table type has a type_table_object_id that is a foreign key into the sys.objects catalog view. This id can be used for querying various catalog views, in a way similar to an object_id of a regular table, for discovering the structure of the table type such as its columns, constraints, etc.
Column name |
Data type |
Description |
|---|---|---|
<inherited columns> |
|
For a list of columns that this view inherits, see sys.types (Transact-SQL). |
type_table_object_id |
int |
Object identification number. This number is unique within a database. |
Permissions
In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.
See Also