-
Type:
How To
-
Status: Published
-
Affects Version/s: EXASolution 5.0, EXASOL 6.0.0, Exasol 6.1.0, Exasol 6.2.x
-
Fix Version/s: None
-
Component/s: EXASolution
-
Labels:None
-
Solution:
Background
EXAplus provides the functionality to create the DDL for a specific solution.
How to a create table DDL Lua script
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
Background EXAplus provides the functionality to create the DDL for a specific solution. How to a create table DDL Lua script 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
-
- Published