CREATE DATABASE, CREATE TABLE, DROP, ALTER notes| DDL

Data Definition Language (DDL) in MySQL

Data Definition Language (DDL) forms a core subset of SQL commands used to create, modify, and manage database structures. Unlike manipulation statements which handle actual records, DDL changes the fundamental schema of database objects. Here is a definitive practical guide to the fundamental core operations: CREATE, DROP, and ALTER.

1 CREATE

Establishes entirely new structures such as physical database directories or target relation tables.

2 ALTER

Modifies structural properties, modifying constraints, data attributes, or individual columns.

3 DROP

Destroys structural components and configurations completely from system indices.

1. CREATE DATABASE

The CREATE DATABASE statement generates a new physical directory file container under your relational server setup instance.

Syntax Structure

CREATE DATABASE database_name;

Practical Example

CREATE DATABASE SchoolDB;

2. CREATE TABLE

The CREATE TABLE command builds structured tracking matrix relations inside active environments, requiring explicitly outlined column schemas, relational configurations, and specific target data types.

Syntax Structure

CREATE TABLE table_name (
    column1 datatype constraints,
    column2 datatype constraints,
    ...
);

Practical Example

CREATE TABLE Students (
    StudentID INT PRIMARY KEY AUTO_INCREMENT,
    Name VARCHAR(100) NOT NULL,
    Age INT,
    EnrollmentDate DATE
);

3. DROP

The DROP routine is an absolute administrative tool that destroys architectural entities. Executing a drop query drops tracking indices alongside all historical datasets contained inside structures.

CRITICAL SAFETY WARNING: DROP runs instantly without a confirmation prompt. Executing this statement completely and permanently removes the component along with its entire record collection. Recovery is impossible without complete server backup files.