SQL Data Definition/Description Language (DDL)
- is a type of Structured Query Language (SQL) used for DEFINING data structures (e.g. tables, indices, etc)
- these include:
- CREATE
- ALTER
- DROP
- TRUNCATE - used to remove all rows from a table without logging the individual row deletions
- and also Referential Actions, such as CASCADE, RESTRICT, NO ACTION, SET NULL, and SET DEFAULT.