Generating DDL Statements for Database Objects

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

Generating DDL Script

  1. On the Database menu, click Generate Schema Script.
  2. On the General tab, set up a database connection.
  3. Check database objects for DDL script generation. (If you run the wizard from the shortcut menu of the 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 DDL generation options you want to tweak. You can set default values of these options in the Options dialog.

  6. Click Generate.

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