The syntax of a check constraint: CHECK (condition) : Check Options « Constraints « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Constraints
  3. Check Options

The syntax of a check constraint: CHECK (condition)

 


A column-level check constraint that limits Billings to positive amounts
A statement that defines the check constraint


11> CREATE TABLE Billings
12> (BillingID       INT   NOT NULL IDENTITY PRIMARY KEY,
13> BillingTotal     MONEY NOT NULL CHECK (BillingTotal > 0))
14> GO
1>
2> --An INSERT statement that fails due to the check constraint
3>
4> INSERT Billings VALUES (-100)
5> GO
Msg 547, Level 16, State 1, Server J\SQLEXPRESS, Line 4
The INSERT statement conflicted with the CHECK constraint "CK__Billings__Invoic__6D230CE4". The conflict occurred in database "master", table "dbo.Billings", column 'BillingTotal'.
The statement has been terminated.
1>
2> drop table Billings;
3> GO
1>








Related examples in the same category

1.Blocking Empty and Missing Character Input
2.WITH CHECK OPTION says any INSERT or UPDATE statements must meet that where clause criteria
3.A statement that creates a table with two column-level check constraints
4.check constraints coded at the table level
5.Mark constraint with nocheck when creating a constraint