Snippet Name: Add constraint example Description: Example of adding a constraint. Also see:» Check Constraint: Create » Unique Constraint » Primary Key Constraint » Foreign Key Constraints » Current_timestamp » Deferring Constraint Checking » Add Primary Key Constraint example » Constraint Checks Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 20th, 2009
Description: Example of adding a constraint.
Also see:» Check Constraint: Create » Unique Constraint » Primary Key Constraint » Foreign Key Constraints » Current_timestamp » Deferring Constraint Checking » Add Primary Key Constraint example » Constraint Checks
ALTER TABLE airplanes ADD CONSTRAINT program_fk FOREIGN KEY ( program_id ) REFERENCES programs ( program_id );