Cross-table constraints in SQL? syncrotic Mar 29, 2010 Jump to latest Follow Reply ...

I get 2 groups of 4 check boxes and 3 radio buttons.<BR><BR>the bottom check box lets me:<BR>Script PRIMARY keys, FOREIGN keys, defaults, and check constraints.

-- CONSTRAINTS -- --------------- -- Constraints can be at column level or table level. -- They are used to specify rules for the data in a table by limiting the type of data that can go into a table.

In SQL, a trigger responds to events like inserting, updating, or deleting data. On the other hand, a constraint is like a rule in a game. Imagine a rule that says, "You can't use your hands." ...

is the name for the constraint being specified. The first form of the CREATE TABLE statement creates tables that automatically map SQL data types to those supported by the SAS System. Use this form ...