SQL - Data Definition / Data Dictionary Language (DDL)

> (Data|State) Management and Processing > (Data Type|Data Structure) > (Relation|Table) - Tabular data > Structured Query Language (SQL)

Table of Contents

1 - About

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
Advertising
data/type/relation/sql/ddl.txt · Last modified: 2017/09/13 21:21 by gerardnico