What is an DDL file? A file with .ddl extension is a Data Definition Language file that is used to define the schema of a database. It contains statements/commands for working with database structures such as tables, columns, records, and other fields. Commands in a DDL file are written in SQL and can perform operations such as create table in database, drop and update. A database schema is owned by its created and all the CRUD operations can be performed on it.