AI engineering glossary · SQL databases
What is DDL?
DDL (also called Data definition language): Data definition language: the SQL statements that create or change the structure of a database, such as CREATE, ALTER and DROP. In many systems they take effect immediately or need special handling in transactions.
DDL: an example
CREATE TABLE products (id INT PRIMARY KEY, name TEXT); defines a new table.
Related terms
More SQL databases terms
- DELETE
- Denormalization
- Dirty read
- DISTINCT
- DML
- Document database
- Entity-relationship model
- Eventual consistency
Where you learn it
DDL is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.