SQL - Table Constraints
Which of the following is the correct syntax to define a FOREIGN KEY constraint when creating a table?
Which of the following is the correct syntax to define a FOREIGN KEY constraint when creating a table?
easy📝 Syntax Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Recall correct foreign key syntax
The correct syntax uses parentheses around the column name and the keyword REFERENCES.Step 2: Compare options
Only FOREIGN KEY (column_name) REFERENCES parent_table(parent_column) uses parentheses and REFERENCES correctly; others miss parentheses or use TO instead of REFERENCES.Final Answer:
FOREIGN KEY (column_name) REFERENCES parent_table(parent_column) -> Option AQuick Check:
Correct syntax = parentheses + REFERENCES [OK]
Quick Trick: Use FOREIGN KEY (col) REFERENCES table(col) syntax [OK]
Common Mistakes:
MISTAKES- Omitting parentheses around column name
- Using TO instead of REFERENCES
- Missing parentheses around referenced column
Master "Table Constraints" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes