CreateUserTable
An internal operation used when GenerateSchemaFiles=OnCreate
This stored procedure is an internal operation that gets executed when running CREATE TABLE statements and GenerateSchemaFiles is set to OnCreate.
Note: This procedure makes use of indexed parameters. Indexed parameters facilitate providing multiple instances a single parameter as inputs for the procedure.
Suppose there is an input parameter named Param#. To input multiple instances of an indexed parameter like this, execute:
EXEC ProcedureName Param#1 = "value1", Param#2 = "value2", Param#3 = "value3"
In the table below, indexed parameters are denoted with a '#' character at the end of their names.
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 |