Data Definition Language; defining database structures but not their contents.
DDL is Data Definition Language, which is a general term used to refer to commands, scripts, or functions that are used to create the structures, objects, and framework of a database.
This can include table definitions, indexes, constraints, foreign key relationships, views, stored procedures, and functions.
In the most general sense, DDL can be any statement that begins wither either CREATE
, DROP
or ALTER
.
DDL is related to but different from dml, or Data Manipulation Language, which is used on the actual data within the database objects.