[Solved] You try to create a table with:CREATE TABLE test (id INT, CONSTRAINT chk_id CHECK id > 0);But get a syntax error. What is the likely cause? | SQL

SQL - Table Constraints

You try to create a table with:

CREATE TABLE test (id INT, CONSTRAINT chk_id CHECK id > 0);

But get a syntax error. What is the likely cause?

AMissing parentheses around the CHECK condition.

BCHECK constraints cannot be named.

CCONSTRAINT keyword is not allowed in table creation.

DThe condition must be written as a string.

Step-by-Step Solution

Solution:

Step 1: Review syntax for table-level CHECK constraints
Table-level CHECK constraints require the condition inside parentheses.
Step 2: Identify missing parentheses
The condition 'id > 0' is missing parentheses, causing syntax error.
Final Answer:
Missing parentheses around the CHECK condition. -> Option A
Quick Check:
CHECK condition must be in parentheses [OK]

Quick Trick: Always wrap CHECK condition in parentheses [OK]

Common Mistakes:

MISTAKES

Master "Table Constraints" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

You try to create a table with: