DDL

Updated: 11/12/2023 by Computer Hope
DDL or data definition language

A DDL may refer to any of the following:

1. Short for data definition language, DDL is a subset of SQL (Structured Query Language) used for defining and managing the schema of a relational database. It includes commands that allow you to define, change, and remove database objects like tables, indices, users, and views. Essentially, DDL is like a computer programming language that deals with the structure of a database, rather than the data itself.

DDL statement examples

Below are some common statements used in DDL.

  • CREATE - Creates a new database object, such as a table or index.
  • ALTER - Used to modify the structure of an existing database object. For instance, adding or deleting rows in a table.
  • DROP - Deletes an object from a database.

2. DDL is sometimes used as an acronym for drop-down list, which is another name for a drop-down menu.

Column, Computer acronyms, Database terms, DBMS, Drop, Index, Object, RDBMS, Row, SQL, Syntax