DDL Script Files
The Data Definition Language (DDL) script files contain the Create, Alter, and Drop SQL statements.
You can specify a file name, location, and target database type when you generate the script files. The Developer tool appends the script file names with the "_create" and "_drop" labels. Virtual columns are not part of the DDL script files.
Creating DDL Scripts from an Enterprise Discovery Profile
When you generate DDL script files from an enterprise discovery profile, you can choose the location where you want to save the script files. You can also choose the database type that you want to run the scripts against. Make sure that you verify and commit all the necessary changes in the enterprise discovery profile before you generate DDL scripts.
1. In the Object Explorer view, select an enterprise discovery profile.
2. Right-click the profile, and select Generate DDL.
The Generate DDL dialog box appears.
3. Click Browse to open the Save As dialog box.
The default file extension is .sql.
4. Choose a file location, and enter a file name.
5. Select the type of target database.
6. Click OK.
The Developer tool generates the DDL script files in the location you specified.