[SOL-234] Create table DDL Lua script - Issue Tracker

XML

Word

Printable

Solution:
Hide

EXAplus provides the functionality to create the DDL for a specific solution.
The attached file CREATE_TABLE_DDL.sql provides a Lua script to do the same without EXAplus.

Example call:

execute script my_create_table_ddl('SOURCE_SCHEMA', 'SOURCE_TABLE', 'TARGET_SCHEMA', 'TARGET_TABLE', true) ;

If the last parameter is 'true', the script will add the "OR REPLACE" option
Show
EXAplus provides the functionality to create the DDL for a specific solution. The attached file CREATE_TABLE_DDL.sql provides a Lua script to do the same without EXAplus. Example call: execute script my_create_table_ddl( 'SOURCE_SCHEMA' , 'SOURCE_TABLE' , 'TARGET_SCHEMA' , 'TARGET_TABLE' , true ) ; If the last parameter is 'true', the script will add the "OR REPLACE" option
Category 1:
Database Administration

relates

SOL-231 Copy Database script