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)
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें