Scripting - GenDDL

This script statement will generate the DDL for a number of tables in a schema.

To create the GenDDL script statement:

• go to the Generate DDL window
• select options as you require
• click on File > View Script Statement
• copy the text into the Run SQL window or your batch script

Schema

One parameter in the GenDDL script is schema. AQT will generate the DDL for all objects in this schema.

You can use the filter parameter to specify a subset of tables to be generated.

Advanced Query Tool

https://www.querytool.com

© 2023 Cardett Associates Ltd. All rights reserved.