Class CompatibilitySchema.ETable

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.systypes (Transact-SQL)

Applies to: √ SQL Server (all supported versions) √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW)

Returns one row for each system-supplied and each user-defined data type defined in the database.

important

This SQL Server 2000 system table is included as a view for backward compatibility. We recommend that you use the current SQL Server system views instead. To find the equivalent system view or views, see Mapping System Tables to System Views (Transact-SQL). This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

See sys.systypes.

[Table(Schema = "sys", Name = "systypes", IsView = true)]
public class CompatibilitySchema.ETable

Inheritance

object

CompatibilitySchema.ETable

Extension Methods

Map.DeepCopy<T>(T)

Properties

Allownulls

Indicates the default nullability for this data type. This default value is overridden by if nullability is specified by using CREATE TABLE or ALTER TABLE.

[Column("allownulls")]
[Nullable]
public bool? Allownulls { get; set; }

Property Value

bool?

Collation

If character based, collation is the collation of the current database; otherwise, it is NULL.

[Column("collation")]
[Nullable]
public string? Collation { get; set; }

Property Value

string

CollationID

If character based, collationid is the id of the collation of the current database; otherwise, it is NULL.

[Column("collationid")]
[Nullable]
public int? CollationID { get; set; }

Property Value

int?

Domain

ID of the stored procedure that contains integrity checks for this data type.

[Column("domain")]
[NotNull]
public int Domain { get; set; }

Property Value

int

Length

Physical length of the data type.

[Column("length")]
[NotNull]
public short Length { get; set; }

Property Value

short

Name

Data type name.

[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

Prec

Level of precision for this data type.

-1 = xml or large value types.

[Column("prec")]
[Nullable]
public short? Prec { get; set; }

Property Value

short?

PrintFmt

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

[Column("printfmt")]
[Nullable]
public string? PrintFmt { get; set; }

Property Value

string

Reserved

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

[Column("reserved")]
[Nullable]
public short? Reserved { get; set; }

Property Value

short?

Scale

Scale for this data type, based on precision.

NULL = Data type is nonnumeric.

[Column("scale")]
[Nullable]
public byte? Scale { get; set; }

Property Value

byte?

Status

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

[Column("status")]
[Nullable]
public byte? Status { get; set; }

Property Value

byte?

Tdefault

ID of the stored procedure that contains integrity checks for this data type.

[Column("tdefault")]
[NotNull]
public int Tdefault { get; set; }

Property Value

int

TypeColumn

Physical storage data type.

[Column("type")]
[NotNull]
public byte TypeColumn { get; set; }

Property Value

byte

UID

Schema ID of the owner of the type.

For databases upgraded from an earlier version of SQL Server, the schema ID is equal to the user ID of the owner.

Important *</strong>* If you use any of the following SQL Server DDL statements, you must use the sys.types catalog view instead of sys.systypes.

ALTER AUTHORIZATION ON TYPE

CREATE TYPE

Overflows or returns NULL if the number of users and roles exceeds 32,767.

[Column("uid")]
[Nullable]
public short? UID { get; set; }

Property Value

short?

UserType

User type ID. Overflows or returns NULL if the number of data types exceeds 32,767.

[Column("usertype")]
[Nullable]
public short? UserType { get; set; }

Property Value

short?

Variable

Variable-length data type.

1 = True

0 = False

[Column("variable")]
[NotNull]
public bool Variable { get; set; }

Property Value

bool

XPrec

Internal precision, as used by the server. Not to be used in queries.

[Column("xprec")]
[NotNull]
public byte XPrec { get; set; }

Property Value

byte

XScale

Internal scale, as used by the server. Not to be used in queries.

[Column("xscale")]
[NotNull]
public byte XScale { get; set; }

Property Value

byte

XType

Physical storage type.

[Column("xtype")]
[NotNull]
public byte XType { get; set; }

Property Value

byte

XUserType

Extended user type. Overflows or returns NULL if the number of data types exceeds 32,767.

[Column("xusertype")]
[Nullable]
public short? XUserType { get; set; }

Property Value

short?