Viewing and updating the database DDL
When you create a database for a database type other than XML or JSON, the database details include a DDL tab. If you used a SQL DDL script to create the database, then Fabricate populates the DDL tab with that script.
From the DDL tab, you can update the DDL.
When you update the DDL, you also choose whether Fabricate automatically changes the database schema to match the new DDL. When Fabricate updates the database, it adds and removes tables and columns. It does not touch columns and tables that you exclude from the database export. For more information, go to Indicating whether to include the table in the export and Excluding the column from exported data.
To change the DDL:
Click Update DDL.
On the Update DDL panel, paste the new DDL into the text area.
By default, when you update the DDL, Fabricate updates the database to match it. To only save the new DDL, but not use it to update the database, check the Don't make any changes to my database checkbox.
Optionally, under More options, in the AI Hints field, provide additional hints about how to use the revised DDL to update the database. For example, you might suggest generators to use for new columns or limits on column values.
Click Apply.
Note that Fabricate does not automatically update the DDL to reflect manual changes to the database schema. For example, when you add or remove tables or columns, Fabricate does not update the DDL.
Last updated