Snippet Name: Check Constraint: Create Description: A check constraint allows you to specify a condition on a column in a table. Also see:» Unique Constraint » Primary Key Constraint » Foreign Key Constraints » Current_timestamp » Deferring Constraint Checking » Add Primary Key Constraint example » Constraint Checks » Add constraint example Comment: (none) Language: Highlight Mode: PLSQL Last Modified: March 07th, 2009
Description: A check constraint allows you to specify a condition on a column in a table.
Also see:» Unique Constraint » Primary Key Constraint » Foreign Key Constraints » Current_timestamp » Deferring Constraint Checking » Add Primary Key Constraint example » Constraint Checks » Add constraint example
ALTER TABLE ADD CONSTRAINT <constraint_name> CHECK (<column_name> != <value>); ALTER TABLE ADD CONSTRAINT cc_status CHECK (status IN (1,2,3,4); TO enforce formatting ALTER TABLE person ADD CONSTRAINT cc_p_ssn CHECK (ssn LIKE '___-__-____');
