What is DDL?

Joe Sam Shirah

DDL is an abbreviation for Data Definition Language. This portion of the SQL standard is concerned with the creation, deletion and modification of database objects like tables, indexes and views. The core verbs for DDL are CREATE, ALTER and DROP. While most DBMS engines allow DDL to be used dynamically ( and available to JDBC ), it is often not supported in transactions. See When I intersperse table creation or other DDL statements with DML statements, I have a problem with a transaction being commited before I want it to be for more information.