Sql Create Drop Table — Free Sql Tutorial

TL;DR: Learn Sql Create Drop Table in Sql with a free, beginner-friendly tutorial, examples and practice for Indian students on Syllab.in.

Sql Create 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 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 Sql Create 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 →