Note: This solution is no longer maintained. For the latest information, please visit our Knowledge Base: https://community.exasol.com/t5/database-features/create-ddl-for-a-table/ta-p/1418 ------------------------------------------------------------------------------------------------------------------------------------------------------------------ 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