CREATE TABLE

CREATE TABLE is a SQL statement in the DDL Statements category. Creates a new table in the database with specified columns, data types, and constraints. The syntax is CREATE TABLE table_name (column1 datatype constraints, column2 datatype constraints, ...);. It returns new table. A typical example: CREATE TABLE employees ( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100) NOT NULL, email VARCHAR(255) UNIQUE, salary DECIMAL(10, 2) DEFAULT 0, dept_id INT, FOREIGN KEY (dept_id) REFERENCES departments(id) ); A close relative is ALTER TABLE, which modifies an existing table: add/drop columns, modify data types, rename, add/drop constraints. A close relative is DROP TABLE, which permanently removes a table and all its data from the database. Cannot be undone. A close relative is TRUNCATE TABLE, which removes ALL rows from a table quickly. Unlike DELETE, cannot be rolled back in most databases. Resets AUTO_INCREMENT. More about this category: Data Definition Language — CREATE TABLE, ALTER TABLE, DROP TABLE, TRUNCATE, CREATE INDEX.