Use or to link two conditions for check constraint : Check « Constraints « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Constraints
  3. Check
2> CREATE TABLE publishers
3> (
4>    pub_id         char(4)           NOT NULL
5>          CONSTRAINT UPKCL_pubind PRIMARY KEY CLUSTERED
6>          CHECK (pub_id in ('1389', '0736', '0877', '1622', '1756') OR pub_id like '99[0-9][0-9]'),
7>
8>    pub_name       varchar(40)           NULL,
9>    city           varchar(20)           NULL,
10>    state          char(2)               NULL,
11>
12>    country        varchar(30)           NULL
13>
14>          DEFAULT('USA')
15> )
16>
17> GO








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