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:

1. 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. For details, see Security Disclaimer.

2. Click OK.

   The Save As dialog box is displayed.

   

3. 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 details, see Canceling the Table Data Export Operation.
   • If the file name contains characters that are not supported by Windows, the file name will be different from the schema name.
   • MS Visual C runtime file (msvcrt100.dll) is required to complete this operation. For details, see Troubleshooting.

   The Export message and the status bar display the status of the completed operation.

   Database Encoding	File Encoding	Support for Exporting a 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

   

   You can select multiple objects and export their DDL. Batch Export lists the objects whose DDL cannot be exported.