DDL history

When managing numerous databases and doing lots of schema changes, it's useful to have a tool to track and reproduce changed made on the schema. SQLiteStudio shows the DDL preview before executing database object creation/change statements (unless this option was disabled by user). It gets the job done, but it can be clunky to copy the DDL and paste to some it to some other text file to keep the history. It's also risky, cause one might forget to copy the DDL sometimes.

That's where the DDL history window comes in. It keeps history of any DDL changes (CREATE statements, DROP statements and any other statements related to changes of database objects), regardless of DDL preview dialog being enabled or not. It keeps information about date and time of execution and database on which the DDL was executed.

Together with SQL history from SQL Editor, DDL history window makes any changes made to any database from SQLiteStudio reproducible.

To open DDL history window, click on "DDL history" button on the main toolbar, or with configured hotkey (by default Ctrl+H or Cmd+H on macOS).