DDL: CREATE, ALTER, DROP

DDL (Data Definition Language) groups the statements that define the database structure: CREATE creates an object, ALTER modifies it (adding a column or constraint), DROP deletes it permanently. It is distinct from DML (INSERT, UPDATE, DELETE), which manipulates the data. DROP is irreversible without a backup.

Example

ALTER TABLE clients ADD COLUMN telephone text;

Related concepts

The whole glossary