AppLib CREATE TABLE FROM SOURCE TABLE

From LucidDB Wiki
Jump to: navigation, search

Contents

Syntax 

CALL APPLIB.CREATE_TABLE_FROM_SOURCE_TABLE( sourceTable, schemaName, tableName, additionalColsInfo )

Purpose

Creates a table with the same structure as the source table, optionally adding a few additional columns

Parameters

  • sourceTable: Full identifier for the source table [VARCHAR(1024)]
  • schemaName: name of schema to create the table in [VARCHAR(128)]
  • tableName: name of table to create [VARCHAR(128)]
  • additionalColsInfo: [VARCHAR(65535)]

Example

Retrieved from "http://luciddb.org/wiki/index.php?title=AppLib_CREATE_TABLE_FROM_SOURCE_TABLE&oldid=6814"
Product Documentation