| Term | Definition |
|---|
| ALTER TABLE table_name ADD FOREIGN KEY (column_name) REFERENCES table_name (column_name) | to create a FOREIGN KEY constraint on a column when the table is already created |
| ALTER TABLE table_name ADD CONSTRAINT constraint_name FOREIGN KEY (column_name) REFERENCES table_name (column_name) | to allow naming of a FOREIGN KEY constraint, and for defining a FOREIGN KEY constraint on multiple column |
| ALTER TABLE table_name DROP CONSTRAINT constraint_name | to drop a FOREIGN KEY constraint |
| CREATE TABLE table_name (column_name1, NOT NULL, column_name2, PRIMARY KEY (column_name),FOREIGN KEY REFERENCES table (column_name)) | to create a table with a FOREIGN KEY constraint on a column |
| FOREIGN KEY | points to a PRIMARY KEY in another table |
Combine with other sets
Share on Facebook
Share on MySpace