Exporting Schema DDL
Exporting the schema DDL exports the DDLs of functions/procedures, tables, sequences and views of the schema.
Follow the steps to export the schema DDL:
- In the Object Browser pane, right-click the selected schema and select Export DDL.
The Data Studio Security Disclaimer dialog box is displayed. You can close this security disclaimer message. Refer to Security Disclaimer section for more information.
- Click OK.
The Save As dialog box is displayed.
- In the Save As dialog box, select the location to save the DDL and click Save. The status bar displays the progress of the operation.
- To cancel the export operation, double-click the status to open the Progress View tab and click
. For more information refer to Canceling the export table data operation. - The exported file name will not be the same as schema name, if the schema name contains characters which are not supported by Windows.
- Microsoft Visual C runtime file (msvcrt100.dll) is required to complete this operation. Refer to Troubleshooting section for more information.
The Export message and the status bar display the status of the completed operation.
Database Encoding
File Encoding
Supports Exporting DDL
UTF-8
UTF-8
Yes
GBK
Yes
LATIN1
Yes
GBK
GBK
Yes
UTF-8
Yes
LATIN1
No
LATIN1
LATIN1
Yes
GBK
No
UTF-8
Yes
Multiple objects can be selected to export DDL. Refer to Batch Export section for list of objects not supported for export DDL operation.
- To cancel the export operation, double-click the status to open the Progress View tab and click
Last Article: Creating a Schema
Next Article: Exporting Schema DDL and Data
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.