sys.table_types (Transact-SQL)
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
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 type_table_object_id that is a foreign key into the sys.objects catalog view. You can use this ID column to query various catalog views, in a way that is similar to an object_id column of a regular table, to discover the structure of the table type such as its columns and constraints.
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. |
is_memory_optimized | bit | Applies to: SQL Server 2014 (12.x) and later. The following are the possible values: 0 = is not memory optimized 1 = is memory optimized A value of 0 is the default value. Table types are always created with DURABILITY = SCHEMA_ONLY. Only the schema is persisted on disk. |
Permissions
The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.
See Also
Object Catalog Views (Transact-SQL)
Use Table-Valued Parameters (Database Engine)
In-Memory OLTP (In-Memory Optimization)
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru