A statement that creates a table with two column-level check constraints : Check Options « Constraints « SQL Server / T-SQL






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

A statement that creates a table with two column-level check constraints

 


5>
6> CREATE TABLE Billings
7> (BillingID       INT   NOT NULL IDENTITY PRIMARY KEY,
8> BillingTotal     MONEY NOT NULL CHECK (BillingTotal >= 0),
9> PaymentTotal     MONEY NOT NULL DEFAULT 0
10> CHECK (PaymentTotal >= 0))
11> GO
1>
2> drop table Billings;
3> GO
1>








Related examples in the same category

1.The syntax of a check constraint: CHECK (condition)
2.Blocking Empty and Missing Character Input
3.WITH CHECK OPTION says any INSERT or UPDATE statements must meet that where clause criteria
4.check constraints coded at the table level
5.Mark constraint with nocheck when creating a constraint