TDV Adapter for Couchbase

Build 22.0.8462

CreateUserTable

An internal operation used when GenerateSchemaFiles=OnCreate

Note: This procedure makes use of indexed parameters. These input parameters are denoted with a '#' character at the end of their names.

Indexed parameters facilitate providing multiple instances a single parameter as inputs for the procedure.

Suppose there is an input parameter named Param#. Input multiple instances of an indexed parameter like this:

EXEC ProcedureName Param#1 = "value1", Param#2 = "value2", Param#3 = "value3"

Input

Name Type Required Description
CreateNotExist String False Whether an existing table is an error or not
TableName String False The name of the table to create
ColumnNames# String False For each column, its name
ColumnDataTypes# String False For each column, its type
ColumnSizes# String False For each column, its size (ignored)
ColumnScales# String False For each column, its scale (ignored)
ColumnIsNulls# String False For each column, whether it allows NULLs (ignored)
ColumnDefaults# String False For each column, its default value (ignored)
Location String False Where the schema file is generated

Result Set Columns

Name Type Description
AffectedTables String The number of tables created, either 0 or 1

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462