Extract DDL enhancements

 

 

When generating DDL, this version of SQL Navigator encloses non-alphanumeric and mixed-case object names inside double-quotes rather than generating error as previously.

You can select the case for the SQL keywords in DDL: upper, lower, or initial capitals.

The Extract DDL function includes partition information when generating a script.

Extract DDL runs as a background task. You can select multiple objects, start an extract DDL task, and keep on working while it runs.

 

image\btn_More_About_Extracting_DDL96.gif