SQL - Table Constraints
Which of the following is the correct syntax to name a UNIQUE constraint on the column
Email in table Users?Which of the following is the correct syntax to name a UNIQUE constraint on the column Email in table Users?
easy📝 Syntax Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Recall the syntax for naming UNIQUE constraints
The syntax is CONSTRAINT constraint_name UNIQUE (column_name).Step 2: Check naming convention and syntax correctness
CONSTRAINT UQ_Users_Email UNIQUE (Email) uses the correct syntax and a clear naming convention: UQ prefix, table name, column name.Final Answer:
CONSTRAINT UQ_Users_Email UNIQUE (Email) -> Option CQuick Check:
Unique constraint syntax = D [OK]
Quick Trick: Use UQ prefix + table + column for unique constraints [OK]
Common Mistakes:
MISTAKES- Placing UNIQUE before CONSTRAINT
- Wrong order of table and column in name
- Using invalid syntax
Master "Table Constraints" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes