Oracle PL/SQL: Add constraint example - Example of adding a constraint.

Quick Search:

Oracle PL/SQL: Add constraint example

Jump to:

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

ALTER TABLE airplanes
ADD CONSTRAINT program_fk FOREIGN KEY ( program_id )
REFERENCES programs ( program_id );