[Solved] Consider this table creation:CREATE TABLE Orders (OrderID INT PRIMARY KEY, CustomerID INT, FOREIGN KEY CustomerID REFERENCES Customers(CustomerID));What is wrong with this statement? | SQL

SQL - Table Relationships

Consider this table creation:
CREATE TABLE Orders (OrderID INT PRIMARY KEY, CustomerID INT, FOREIGN KEY CustomerID REFERENCES Customers(CustomerID));
What is wrong with this statement?

AForeign key cannot reference Customers table

BCustomerID should be declared as PRIMARY KEY

CPRIMARY KEY must be declared after FOREIGN KEY

DMissing parentheses around the foreign key column name

Step-by-Step Solution

Solution:

Step 1: Check foreign key syntax
The foreign key column name must be enclosed in parentheses after FOREIGN KEY.
Step 2: Identify the error in the statement
The statement uses FOREIGN KEY CustomerID without parentheses, which is invalid syntax.
Final Answer:
Missing parentheses around the foreign key column name -> Option D
Quick Check:
FOREIGN KEY (col) needs parentheses [OK]

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

Common Mistakes:

MISTAKES

Omitting parentheses in FOREIGN KEY declaration
Misordering PRIMARY and FOREIGN KEY declarations
Confusing foreign key with primary key requirements

Master "Table Relationships" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Consider this table creation:

Step 1: Check foreign key syntax

Step 2: Identify the error in the statement

Final Answer:

Quick Check:

Want More Practice?