Prev Up Next
9.12.ALTER TABLE Statement Home 9.13.CREATE VIEW Statement

9.12.1.Adding a CHECK Constraint

A CHECK constraint can be added to a table after it has been created and populated providing that none of the tables contents would violate the constraint.

Example9.28.Adding a CHECK constraint to an existing table. 

CREATE TABLE test_add_check (
  name VARCHAR,
  age INTEGER
  )
;

ALTER TABLE test_add_check ADD CONSTRAINT chkage CHECK (age > 18);

[Tip] See Also:

The CHECK constraint

Prev Up Next
9.12.ALTER TABLE Statement Home 9.13.CREATE VIEW Statement