Uploaded image for project: 'Solution Center'
  1. Solution Center
  2. SOL-234

Create table DDL Lua script

    XMLWordPrintable

    Details

    • Type: How To
    • Status: Published
    • Affects Version/s: EXASolution 5.0, EXASOL 6.0.0, Exasol 6.1.0
    • Fix Version/s: None
    • Component/s: EXASolution
    • Labels:
      None
    • 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

      Attachments

        Issue Links

          Activity

            People

            • Assignee:
              CaptainEXA Captain EXASOL
              Reporter:
              CaptainEXA Captain EXASOL
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated: