Loading subject…
Data definition language (DDL)
The subset of SQL that defines and changes the structure of a database, using commands such as CREATE, ALTER, DROP, TRUNCATE and RENAME. DDL acts on database objects rather than on the rows stored inside them.
Data manipulation language (DML)
The subset of SQL that works with the rows held in a structure that already exists, using SELECT, INSERT, UPDATE and DELETE. DML cannot change the definition of a table.