Generating DDL Statements for Database Objects

dbForge Fusion for SQL Server allows you to generate DDL statements for database objects, such as tables, views, stored procedures and functions, UDFs and triggers. With this feature, you can make scripts for recreating database objects or object groups.

Generating DDL Script

  1. On the Fusion menu, select SQL Server, and then click Generate Scripts.

  2. On the General tab, set up a database connection.

  3. Check database objects for DDL script generation. (If you run the wizard on the shortcut menu of a single object node, this step will be skipped. You can return to it by clicking the Back button on the Script Generation Options page).

  4. Click Next if the Script Generation Options page was not turned off and go to step 4, otherwise, go to step 5.

  5. Select the DDL generation options you want to alter. You can set default values of these options in the Options dialog box.

  6. Click Generate.

You can turn off Generate Schema Script Wizard appearing while generating the DDL statement for the single object.