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 |