[Solved] Which of the following is the correct syntax to add a NOT NULL constraint to a column named email when creating a table?CREATE TABLE users ( id INT PRIMARY KEY, email ???); | SQL

SQL - Table Constraints

Which of the following is the correct syntax to add a NOT NULL constraint to a column named email when creating a table?

CREATE TABLE users (
  id INT PRIMARY KEY,
  email ???
);

ANULL VARCHAR(255)

BNOT NULL VARCHAR(255)

CVARCHAR(255) NULL

DVARCHAR(255) NOT NULL

Step-by-Step Solution

Solution:

Step 1: Recall correct order of column definition
The data type comes first, then constraints like NOT NULL.
Step 2: Check each option's order
VARCHAR(255) NOT NULL correctly places VARCHAR(255) before NOT NULL; others have wrong order or use NULL instead.
Final Answer:
VARCHAR(255) NOT NULL -> Option D
Quick Check:
Data type first, then NOT NULL [OK]

Quick Trick: Data type comes before NOT NULL in column definition [OK]

Common Mistakes:

MISTAKES

Master "Table Constraints" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which of the following is the correct syntax to add a NOT NULL constraint to a column named email when creating a table?