Data definition language

This article has multiple issues. Please help improve it or discuss these issues on the talk page. (Learn how and when to remove these messages) This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed. Find sources: "Data definition language" – news · newspapers · books · scholar · JSTOR (December 2012) (Learn how and when to remove this message) This article may require cleanup to meet Wikipedia's quality standards. The specific problem is: the article focuses almost entirely on SQL. Please help improve this article if you can. (June 2020) (Learn how and when to remove this message) (Learn how and when to remove this message)

In the context of SQL, data definition or data description language (DDL) is a syntax for creating and modifying database objects such as tables, indices, and users. DDL statements are similar to a computer programming language for defining data structures, especially database schemas. Common examples of DDL statements include CREATE, ALTER, and DROP. If you see a .ddl file, that means the file contains a statement to create a table. Oracle SQL Developer contains the ability to export from an ERD generated with Data Modeler to either a .sql file or a .ddl file.