Table of Contents

Class ObjectSchema.TableType

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.table_types (Transact-SQL)

Applies to: √ SQL Server (all supported versions) √ Azure SQL Database

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.


See sys.table_types.

[Table(Schema = "sys", Name = "table_types", IsView = true)]
public class ObjectSchema.TableType
Inheritance
ObjectSchema.TableType
Extension Methods

Properties

InheritedColumns

For a list of columns that this view inherits, see sys.types (Transact-SQL).

[Column("*\\<inherited columns>*")]
[NotNull]
public object InheritedColumns { get; set; }

Property Value

object

IsMemoryOptimized

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.

[Column("is_memory_optimized")]
[Nullable]
public bool? IsMemoryOptimized { get; set; }

Property Value

bool?

TypeTableObjectID

Object identification number. This number is unique within a database.

[Column("type_table_object_id")]
[NotNull]
public int TypeTableObjectID { get; set; }

Property Value

int