Mega Code Archive
Check constraints coded at the table level
<![CDATA[
6>
7>
8> CREATE TABLE Billings
9> (BillingID INT NOT NULL IDENTITY PRIMARY KEY,
10> BillingTotal MONEY NOT NULL,
11> PaymentTotal MONEY NOT NULL DEFAULT 0,
12> CHECK ((BillingTotal >= 0) AND (PaymentTotal >= 0)))
13>
14> GO
1>
2> drop table Billings;
3> GO
]]>