Data Manipulation Language (DDL) this portion of the SQL standard is concerned with manipulating the data in a database as opposed to the structure of a database. The DML
deals with the SELECT, INSERT, DELETE, UPDATE, COMMIT
and ROLLBACK
.
Data Definition Language (DDL) this portion of the SQL standard is concerned with the creation, deletion and modification of database objects like tables, indexes and views. The core verbs for DDL
are CREATE, ALTER
and DROP
. While most DBMS engines allow DDL to be used dynamically, it is often not supported in transactions.