📖
Theory
Understand the concept step by step
The CREATE TABLE statement is used to create a new table.
While creating a table, we define:
• Column names
• Data types
• Optional constraints
Each table can contain multiple rows of data.
💻
Example
See how the concept works in SQL
SQL
CREATE TABLE students (
id INT,
name VARCHAR(100),
age INT
);📤
Output
Understand what the query produces
A students table is created with id, name and age columns.
📝
Practice
Test your understanding
Create an employees table with id, name, salary and department columns.
❓
MCQs
Check your SQL knowledge
What is the main concept covered in Create Table?
A.CREATE TABLE
B.BUILD TABLE
C.NEW TABLE
D.MAKE TABLE
💼
Interview Questions
Prepare for SQL interviews
1
Interview Question
Which statement creates a table?
2
Interview Question
What must be defined when creating a table?
3
Interview Question
Can a table have multiple columns?