SQL - Data Definition / Data Dictionary Language (DDL)

Data definition language (DDL) is a category of statement that 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
• GRANT privileges on object
• REVOKE privileges on object
• FLASHBACK restores an earlier version of a table or database
• PURGE removes database objects from the recycle bin
• COMMENT on a particular object
• ANALYZE
• AUDIT
• ASSOCIATE
• STATISTICS
• DISASSOCIATE
• NOAUDIT