- Tech know how online

data definition language (DDL)

The Database Definition Language (DDL) is a database language. It uses SQL statements to define all attributes and properties of a database management system

(DBMS) and to create and manage database objects within a database. The DDL language is used by the information administrator. Common DDL statements include create, age, and drop.

The Create DDL command has a predefined syntax. It is used to build new database tables. The Alter command can be used to modify existing tables. Additional columns can be inserted, existing columns can be deleted, and the data type in the columns can be changed. And the Drop command can be used to delete a table or index.

Informationen zum Artikel
Englisch: data definition language - DDL
Updated at: 31.05.2017
#Words: 93