Can you explain what is meant by DDL in the context of working with databases?

DDL (Data Definition Language) is a subset of SQL commands used for defining and modifying the structure of a database.

The main DDL operations include:

• CREATE — creating new tables, indexes, schemas, and other database objects.
• ALTER — modifying the structure of existing objects (e.g., adding columns to a table).
• DROP — deleting database objects.
• TRUNCATE — quickly removing all data from a table without deleting the table itself.

Example of creating a table using DDL:

CREATE TABLE users (
    id INT PRIMARY KEY,
    username VARCHAR(50) NOT NULL,
    email VARCHAR(100)
);

Thus, DDL is responsible for creating and modifying the database schema, unlike DML (Data Manipulation Language), which works with data.