Solution:Step 1: Review foreign key syntaxThe FOREIGN KEY clause requires parentheses around the column name(s).Step 2: Identify errorIn the statement, FOREIGN KEY ClientID REFERENCES... lacks parentheses around ClientID.Final Answer:The FOREIGN KEY clause is missing parentheses around ClientID -> O

[Solved] You wrote this SQL:CREATE TABLE Sales (SaleID INT PRIMARY KEY, ClientID INT, FOREIGN KEY ClientID REFERENCES Clients(ClientID));Why does this cause an error? | SQL

SQL - Table Relationships

You wrote this SQL:

CREATE TABLE Sales (SaleID INT PRIMARY KEY, ClientID INT, FOREIGN KEY ClientID REFERENCES Clients(ClientID));

Why does this cause an error?

AClients table must be created after Sales table

BClientID must be declared as PRIMARY KEY before referencing

CFOREIGN KEY cannot be used in CREATE TABLE statements

DThe FOREIGN KEY clause is missing parentheses around ClientID

Step-by-Step Solution

Solution:

Step 1: Review foreign key syntax
The FOREIGN KEY clause requires parentheses around the column name(s).
Step 2: Identify error
In the statement, FOREIGN KEY ClientID REFERENCES... lacks parentheses around ClientID.
Final Answer:
The FOREIGN KEY clause is missing parentheses around ClientID -> Option D
Quick Check:
Foreign key columns must be in parentheses [OK]

Quick Trick: Foreign key columns need parentheses [OK]

Common Mistakes:

MISTAKES

Omitting parentheses in FOREIGN KEY clause
Assuming referenced column must be primary key in child table
Incorrect table creation order

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

You wrote this SQL:

Step 1: Review foreign key syntax

Step 2: Identify error

Final Answer:

Quick Check:

Want More Practice?