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

A constraint helps to ensure the integrity and consistency of the data in your database. A constraint can also prevent invalid or duplicate data from being inserted, updated, or deleted from a table.

-- 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.

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 ...