A Data Definition Language (DDL) is a subset of SQL used to define and modify the structure of database objects such as tables, views, indexes, and schemas.

Through DDL commands like CREATE, ALTER, DROP, TRUNCATE, and RENAME, database administrators and developers can establish the blueprint of how data should be organized and stored within a database system.

For example, when creating a table, DDL statements specify the names and data types of columns, primary and foreign key constraints, and other rules that maintain data integrity. This makes DDL fundamental to database design and management, as it provides the foundation upon which data manipulation language (DML) and data querying can occur.

Origin: Don’t do structure changes (ALTER) in traditional DDL manner
References:
Created 2025-02-16