Viewing the Table DDL
Only in DbVisualizer Pro
This feature is only available in the DbVisualizer Pro edition.
The DDL of a table is the CREATE TABLE statement that creates it. To see it, double-click the table in the Databases tab, and select the DDL tab in its Object View tab.
DbVisualizer builds the DDL from the metadata of the database, so some database-specific parts, such as storage clauses, are left out. For some databases, there is also a Native DDL tab, or a tab with a similar name, with the DDL as the database itself writes it, including all clauses.
You can also get the DDL in other ways:
- To insert it in SQL Commander, save it to a file or copy it, right-click the table, select Script Table and choose CREATE. See Generating SQL for a Table.
- To open the same dialog from the editor, drag the table from the Databases tab to SQL Commander.
- To get the DDL in a script, use the @ddl command.