Data definition language
Syntax for defining data structures
Summary
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.
Originally created by BL~enwiki
2/2/2004, 2:16:25 PM
Modified
9/27/2025, 8:52:39 PM
Recent revisions
So what?
Reverted edits by [[Special:Contribs/49.185.161.75|49.185.161.75]] ([[User talk:49.185.161.75|talk]]) to last version by WalkingRadiance
I added a picture of saving a ddl file in Oracle SQL Developer.
I mentioned Data Modeler for SQL Developer.
I added details about a .ddl file.
Add: date. | [[WP:UCB|Use this bot]]. [[WP:DBUG|Report bugs]]. | Suggested by Abductive | #UCB_webform 3178/3850
Rescuing 2 sources and tagging 0 as dead.) #IABot (v2.0.9.2
/* External links */ [[WP:BIDIRECTIONAL]]
/* DROP statement */
Reverted edits by [[Special:Contribs/2402:3A80:1098:EF41:D328:8266:2C99:B149|2402:3A80:1098:EF41:D328:8266:2C99:B149]] ([[User talk:2402:3A80:1098:EF41:D328:8266:2C99:B149|talk]]) to last version by Eevee01
Reverting edit(s) by [[Special:Contributions/41.204.187.5|41.204.187.5]] ([[User_talk:41.204.187.5|talk]]) to rev. 1045777659 by ClueBot NG: [[w:en:WP:RW|(RW 16.1)]]
Reverting possible vandalism by [[Special:Contribs/41.204.187.5|41.204.187.5]] to version by Smhdog. [[WP:CBFP|Report False Positive?]] Thanks, [[WP:CBNG|ClueBot NG]]. (4044466) (Bot)
Add DFDL to list of DDL examples
/* CREATE TABLE statement */
