DDL

How it is used

People say 'the DDL for this table' to mean its CREATE script, or 'DDL changes' for schema changes. DDL often needs higher privileges and extra review, and in some databases, such as MySQL and Oracle, it commits the current transaction automatically.

Example sentences

1. Can you send me the DDL for the invoices table?

2. All DDL changes in production need a ticket and DBA review.

Common collocations

• DDL statement
• DDL changes
• generate DDL
• DDL script

Related terms

• DMLData manipulation language: the SQL statements that work with the data inside tables, mainly INSERT, UPDATE, DELETE and often SELECT.
• CREATE TABLEThe SQL statement that makes a new table, defining its name, its columns with their data types and its constraints such as the primary key.
• ALTER TABLEThe SQL statement that changes the structure of an existing table, for example to add, rename or drop a column or to add a constraint.
• schemaThe structure of a database: its tables, columns, data types, keys and relationships. In some products it is also a named group of tables inside a database.
• migrationA versioned script that changes a database schema in a controlled way, or, more broadly, a project to move data from one database or system to another.

This word in other fields

The same English word can have a different meaning in another field:

• DDL · Software Engineering

More terms: SQL Statements and Queries

• SQL
• query
• SELECT statement
• WHERE clause
• join
• INSERT statement
• UPDATE statement
• DELETE statement
• ORDER BY
• GROUP BY
• aggregate function
• inner join