Here is the description of how to extract the DDL text of multiple stored procedures from Firebird database and export it to a multi-command SQL script.
Note: This task can be also done for other database objects and other database types. See more about database objects.
Steps to Extract and Export DDL
- Open the needed database.
- Switch to the Procedures tab of the Object Browser. If the Object Browser was closed, click a vertical splitter at the left side of the window.
- Right-click the procedure list and choose Multiple Selection.
- Select the procedures to extract DDL from.
- Right-click selected items and choose Generate SQL | DDL | Create DDL Script... menu.
- Choose needed options and click OK. A new SQL window will be created and filled with the script containing the DDL text of the selected database objects.
- Save the script to a file if it is needed.
There is another useful option. You can choose Save DDL to File(s)... instead of Create DDL Script... menu. In this case you will able to save the DDL of the selected procedures either to one destination file or to individual files, one file per procedure. In latter case, you should write a formula to generate file names.
Chosen settings can be saved to file and later loaded from file using the corresponding buttons.
See also