[Solved] This SQL code has an error:CREATE TABLE Orders (id INT, customer_id INT, FOREIGN KEY customer_id REFERENCES Customers(id));What is the error? | SQL

SQL - Table Relationships

This SQL code has an error:

CREATE TABLE Orders (id INT, customer_id INT, FOREIGN KEY customer_id REFERENCES Customers(id));

What is the error?

ANo error, code is correct

BMissing parentheses around foreign key column

CForeign key cannot reference another table

DWrong table name

Step-by-Step Solution

Solution:

Step 1: Check foreign key syntax
FOREIGN KEY columns must be enclosed in parentheses.
Step 2: Identify error in code
The code misses parentheses around customer_id in FOREIGN KEY clause.
Final Answer:
Missing parentheses around foreign key column -> Option B
Quick Check:
Foreign key columns need parentheses [OK]

Quick Trick: Always use parentheses around foreign key columns [OK]

Common Mistakes:

MISTAKES

Master "Table Relationships" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

This SQL code has an error: