Home›Learn›SQL›Create Table
SQL Master CourseBeginner Friendly

Create Table

Learn how to create tables and define their columns.

📘 Chapter 5 / 51⏱️ 8–10 Min Read🎯 Beginner Friendly
Course Progress10%

Course Progress

10%

5 / 51 chapters

📖

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?