Working with DDL definitions
Edit the DDL definition of a database object
-
In the Database tool window (), click a database object.
-
Click the Source Editor button (
) on the toolbar. Alternatively, press Ctrl+B.
Save generated DDL in SQL files
-
In the Database tool window (), right-click a database object and select Ctrl+Alt+G.
-
In the SQL Generator tool window, click the File Output Options icon (
). -
From the Layout list, select a method that you want to use:
-
File per object: generates a set of SQL files.
-
File per object with order: generates a numbered set of SQL files.
-
Go from a reference to its DDL definition
-
In the Setting/Preferences dialog Ctrl+Alt+S, navigate to Database | General.
-
In the Navigation pane, clear the Prefer database view over DDL editor checkbox.
Last modified: 15 June 2021