Mega Code Archive
A statement that creates a table with two column-level check constraints
<![CDATA[
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>
]]>