Exporting the DDL of a Function or Procedure

Perform the following steps to export the DDL of a function or procedure:

1. In the Object Browser pane, right-click the selected function or procedure and select Export DDL.

   The Data Studio Security Disclaimer dialog box is displayed.

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 operation progress.
   

   • To cancel the export operation, double-click the status bar to open the Progress View tab and click . For details, see Canceling Table Data Export.
   • If the file name contains characters that are not supported by Windows, the file name will be different from the schema name.
   • The MS Visual C Runtime file (msvcrt100.dll) is required for this operation. For details, see Troubleshooting.
   • You can export the DDL of multiple objects. For details about the objects whose DDL cannot be exported, see Batch Export.

   The Data Exported Successfully dialog box and status bar display the status of the completed operation.

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