Generating DDL Statements for Schema Objects
dbForge Studio for Oracle allows you to generate DDL statements for schema objects, such as: tables, views, synonyms, sequences, packages, materialized views and materialized view logs, stored procedures and functions, triggers and user types. Using this feature you can make scripts for recreating schema objects or object groups.
Generating DDL Script
- On the Database menu, and then click Generate Schema Script.
- Check schema objects for DDL script generation. (If you run the wizard on 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).
- Click Next if the Script Generation Options page was not turned off and go to step 4, otherwise, go to step 5.
- Select DDL generation options you want to tweak. You can set default values of these options in the Options dialog box.
- Click Generate.
You can turn off Generate Schema Script Wizard appearing when generating the DDL statement for the single object.
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for Oracle.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
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 Oracle?