Table of Contents

Class InformationSchema.CheckConstraint

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

CHECK_CONSTRAINTS (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 CHECK constraint in the current database. This information schema view returns information about the objects to which the current user has permissions.
To retrieve information from these views, specify the fully qualified name of INFORMATION_SCHEMA._view_name_.


See INFORMATION_SCHEMA.CHECK_CONSTRAINTS.

[Table(Schema = "INFORMATION_SCHEMA", Name = "CHECK_CONSTRAINTS", IsView = true)]
public class InformationSchema.CheckConstraint
Inheritance
InformationSchema.CheckConstraint
Extension Methods

Properties

CheckClause

Actual text of the Transact-SQL definition statement.

[Column("CHECK_CLAUSE")]
[Nullable]
public string? CheckClause { get; set; }

Property Value

string

ConstraintCatalog

Constraint qualifier.

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

Property Value

string

ConstraintName

Constraint name.

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

Property Value

string

ConstraintSchema

Name of the schema to which the constraint belongs.

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