A check constraint uses an expression to qualify records that are acceptable for any Inserts or Updates : Check « Constraints « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Constraints
  3. Check
7>
8> CREATE TABLE MyTable(
9>   MyID Int IDENTITY(1, 1) NOT NULL
10>   ,MyDescription nVarChar(50) NOT NULL
11>   , Region nVarChar(10) NOT NULL
12>   , CONSTRAINT PK_ID PRIMARY KEY CLUSTERED (MyID)
13>   , CONSTRAINT CK_Region CHECK (Region
14>                 IN('PNW','SW','MT','CENTRAL','EAST','SOUTH'))
15>   )
16> GO
1>
2> drop table MyTable;
3> GO
1>
2>








7.5.Check
7.5.1.Using CHECK Constraints
7.5.2.Adding a CHECK Constraint to an Existing Table
7.5.3.Constraints with name
7.5.4.CHECK Clause
7.5.5.Check Constraint
7.5.6.CHECK (DATEPART(DAY, GETDATE()) < 28)
7.5.7.A check constraint uses an expression to qualify records that are acceptable for any Inserts or Updates
7.5.8.Use or to link two conditions for check constraint
7.5.9.Using a Multicolumn CHECK Constraint
7.5.10.Check for data length
7.5.11.Pattern based constraint
7.5.12.Mark nocheck for a constraint
7.5.13.A table-level check constraint that limits Banker IDs to a specific format