CREATE TABLE & DROP TABLE — Free SQL Tutorial

Learn CREATE TABLE & DROP TABLE in SQL with a free, beginner-friendly tutorial, examples and practice for Indian students on Syllab.in.

CREATE TABLE & DROP TABLE — Free SQL Tutorial

Learn CREATE TABLE & DROP TABLE in SQL with a free, beginner-friendly tutorial, examples and practice for Indian students on Syllab.in.

✓ 100% Free ✓ No Login Needed ✓ NCERT / CBSE Aligned ✓ Download as PDF

TL;DR: Learn CREATE TABLE & DROP TABLE in SQL with a free, beginner-friendly tutorial, examples and practice for Indian students on Syllab.in.

Written & reviewed by the Syllab.in Academic Team (CBSE/NCERT subject experts) · Updated

🤖 Stuck on any question? Ask Syllab's free AI Tutor for a step-by-step explanation — instant, unlimited, no login.

CREATE TABLE & DROP TABLE in SQL

CREATE TABLE defines a new table with columns and constraints. DROP TABLE removes it permanently. These are DDL (Data Definition Language) commands.

Column definition: column_name datatype [constraints]. Constraints: NOT NULL, UNIQUE, PRIMARY KEY, DEFAULT, CHECK, FOREIGN KEY.

IF NOT EXISTS (CREATE TABLE IF NOT EXISTS) prevents errors if table already exists. CASCADE/RESTRICT options on DROP control behaviour with foreign keys.

CREATE TABLE & DROP TABLE — Syntax

CREATE TABLE table_name (
  column_name datatype constraint,
  column_name datatype constraint,
  PRIMARY KEY (column_name)
);

DROP TABLE table_name;
DROP TABLE IF EXISTS table_name;  -- no error if doesn't exist

Learn CREATE TABLE & DROP TABLE step by step with Syllab's free interactive SQL tutorial — runnable code examples, practice exercises and instant AI feedback, all free with no signup. Explore the full SQL course →