SQL - Data Definition / Data Dictionary Language (DDL)
About
SQL provides a data definition language (DDL) to manipulate the data dictionary of a database.
The three principal commands are:
- CREATE,
- ALTER,
- and DROP
but you can also find:
- TRUNCATE to remove all records from a table, including all spaces allocated for the records are removed
- COMMENT to add comments to the data dictionary
- RENAME to rename an object
