Which Of The Following Statement Is Used To Create The Foreign #375
Which of the following statement is used to create the FOREIGN KEY constraint on an already existing table?
This multiple choice question (MCQ) is related to the book/course
gs gs115 Structured Query Language.
It can also be found in
gs gs115 SQL Constraints - SQL Foreign Key - Quiz No.1.
Which of the following statement is used to create the FOREIGN KEY constraint on an already existing table?
ALTER TABLE table_name ADD CONSTRAINT constraint_name FOREIGN KEY REFERENCES parent_table (column_name);ALTER TABLE table_name ADD CONSTRAINT constraint_name FOREIGN KEY (column_name) REFERENCES parent_table;ALTER TABLE table_name ADD CONSTRAINT constraint_name FOREIGN KEY (column_name) REFERENCES parent_table (column_name);ALTER TABLE table_name ADD CONSTRAINT constraint_name FOREIGN KEY (column_name) REFERENCES (column_name);
