Question

Which of the following is correct syntax for inserting foreign key constraint in a relation?

• A. ALTER TABLE table_name ADD FOREIGN KEY(attribute_name) REFERENCES referenced_table_name(attribute_name)
• B. ADD TABLE table_name ADD FOREIGN KEY(attribute_name) REFERENCES referenced_table_name(attribute_name)
• C. ALTER TABLE table_name REFERENCES referenced_table_name(attribute_name) ADD FOREIGN KEY(attribute_name)
• D. MODIFY TABLE table_name ADD FOREIGN KEY(attribute_name) REFERENCES referenced_table_name(attribute_name)

Answer 1

The Correct Option is A

The correct syntax for adding a foreign key constraint is through ALTER TABLE, adding a FOREIGN KEY and referencing another table.