[Solved] You try to create a table with this statement:CREATE TABLE employees ( id INT, salary INT CHECK salary > 0 );But get a syntax error. What is the likely fix? | SQL

SQL - Table Constraints

You try to create a table with this statement:

CREATE TABLE employees (
  id INT,
  salary INT CHECK salary > 0
);

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

AAdd a semicolon after salary

BAdd parentheses around the CHECK condition: CHECK (salary > 0)

CChange salary to VARCHAR

DRemove the CHECK constraint entirely

Step-by-Step Solution

Solution:

Step 1: Identify syntax for inline CHECK constraints
Inline CHECK constraints require the condition to be inside parentheses.
Step 2: Check the given statement
The statement misses parentheses around salary > 0, causing syntax error.
Final Answer:
Add parentheses around the CHECK condition: CHECK (salary > 0) -> Option B
Quick Check:
Inline CHECK needs parentheses [OK]

Quick Trick: Always use parentheses around CHECK conditions [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 this statement: