Which of the following clauses sets the ProductID field as the foreign key to the Orders table?
A)FOREIGN KEY (ProductID) RELATED TO Orders
B)SET ProductID AS FOREIGN KEY TO Orders
C)CREATE FOREIGN KEY (ProductID) Orders
D)FOREIGN KEY (ProductID) REFERENCES Orders

Question

Quizplus · Accepted Answer

The correct syntax to set a field as a foreign key in SQL is "FOREIGN KEY (column_name) REFERENCES parent_table(column_name)". Therefore, option D is correct as it follows this syntax.

Which of the Following Clauses Sets the ProductID Field as the Foreign