| Term | Definition |
|---|
| ALTER TABLE table_name ADD CONSTRAINT constraint_name CHECK (condition) | to create a CHECK constraint on a column when the table is already created |
| ALTER TABLE table_name DROP CONSTRAINT constraint_name | to drop a CHECK constraint |
| CREATE TABLE table_name (column_name1, NOT NULL CHECK, column_name2, ) | to create a table with a CHECK constraint on a column |
| CHECK | Specifies a condition on a column |
| CREATE TABLE table_name (column_name1, NOT NULL, column_name2, CONSTRAINT constraint_name CHECK (conditoin))) | to allow naming of a CHECK constraint on multiple columns |
Combine with other sets
Share on Facebook
Share on MySpace