Which Of The Following Statement Can Be Used To Apply The #374
Which of the following statement can be used to apply the FOREIGN KEY constraint in SQL?
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 can be used to apply the FOREIGN KEY constraint in SQL?
CREATE TABLE table_name ( column1 datatype constraint, column2 datatype constraint, ... columnn datatype constraint, FOREIGN KEY parent_table (column_name));
CREATE TABLE table_name ( column1 datatype constraint, column2 datatype constraint, ... columnn datatype constraint, FOREIGN KEY REFERENCES parent_table (column_name));
CREATE TABLE table_name ( column1 datatype constraint, column2 datatype constraint, ... columnn datatype constraint, FOREIGN KEY (column_name) REFERENCES (column_name));
CREATE TABLE table_name ( column1 datatype constraint, column2 datatype constraint, ... columnn datatype constraint, FOREIGN KEY (column_name) REFERENCES parent_table (column_name));