Generating DDL Statements for Database Objects

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

Generating Script

In Database Explorer, right-click an object you want to generate a script for (if you need to generate a script for multiple objects, select them with holding the CTRL key), point to Generate Script As and then to a required script type. Select the output option for the script: you can either open it in a new SQL window, or save it to a file or copy it to clipboard.

Note

Scipt generation is also available in the Database Backup and Restore and Database Projects features.

Configuring Scipt Generation Options

To setup script generation options, on the Tools menu, click Options, and expand the Generate Schema Script node.

The Options window allows you to configure both, general script generation options, and options that are specific to the CRUD generation script.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for MySQL.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for MySQL?