Class InformationSchema.DomainConstraint

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

DOMAIN_CONSTRAINTS (Transact-SQL)

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

Returns one row for each alias data type in the current database that has a rule bound to it and that can be accessed by current user.
To retrieve information from these views, specify the fully qualified name of INFORMATION_SCHEMA._view_name_.

See INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS.

[Table(Schema = "INFORMATION_SCHEMA", Name = "DOMAIN_CONSTRAINTS", IsView = true)]
public class InformationSchema.DomainConstraint

Inheritance

object

InformationSchema.DomainConstraint

Extension Methods

Map.DeepCopy<T>(T)

Properties

ConstraintCatalog

Database in which the rule exists.

[Column("CONSTRAINT_CATALOG")]
[Nullable]
public string? ConstraintCatalog { get; set; }

Property Value

string

ConstraintName

Rule name.

[Column("CONSTRAINT_NAME")]
[NotNull]
public string ConstraintName { get; set; }

Property Value

string

ConstraintSchema

Name of schema that contains the constraint.

Important Do not use INFORMATION_SCHEMA views to determine the schema of an object. INFORMATION_SCHEMA views only represent a subset of the metadata of an object. The only reliable way to find the schema of a object is to query the sys.objects catalog view.

[Column("CONSTRAINT_SCHEMA")]
[Nullable]
public string? ConstraintSchema { get; set; }

Property Value

string

DomainCatalog

Database in which the alias data type exists.

[Column("DOMAIN_CATALOG")]
[Nullable]
public string? DomainCatalog { get; set; }

Property Value

string

DomainName

Alias data type.

[Column("DOMAIN_NAME")]
[NotNull]
public string DomainName { get; set; }

Property Value

string

DomainSchema

Name of schema that contains the alias data type.

Important Do not use INFORMATION_SCHEMA views to determine the schema of a data type. The only reliable way to find the schema of a type is to use the TYPEPROPERTY function.

[Column("DOMAIN_SCHEMA")]
[Nullable]
public string? DomainSchema { get; set; }

Property Value

string

InitiallyDeferred

Specifies whether constraint checking is at first deferred. Always returns NO.

[Column("INITIALLY_DEFERRED")]
[NotNull]
public string InitiallyDeferred { get; set; }

Property Value

string

IsDeferrable

Specifies whether constraint checking is deferrable. Always returns NO.

[Column("IS_DEFERRABLE")]
[NotNull]
public string IsDeferrable { get; set; }

Property Value

string