CreateUserTable
Creates a schema definition for a MongoDB collection, mapping document structure to a tabular format.
Input
| Name | Type | Description |
| CatalogName | String | The catalog that contains the MongoDB collection. |
| SchemaName | String | The schema associated with the MongoDB collection. |
| TableName | String | The name of the MongoDB collection for which a schema definition is being created. |
| Location | String | The file path where the generated schema definition will be saved. |
| ColumnNames# | String | A list of column names to be included in the schema. |
| ColumnDataTypes# | String | Specifies the data type for each column in the schema. |
| ColumnSizes# | String | Defines the maximum size allowed for each column where applicable. |
| ColumnScales# | String | Specifies the number of decimal places for numeric columns. |
| ColumnIsKeys# | String | Indicates whether a column is a primary key ('true' for key columns, 'false' otherwise). |
| ColumnIsNulls# | String | Defines whether a column allows null values ('true' for nullable columns, 'false' otherwise). |
| ColumnDefaults# | String | Specifies default values assigned to columns if no value is provided during data insertion. |
| ColumnAutoIncrements# | String | Indicates whether a column uses auto-increment functionality ('true' for auto-increment columns, 'false' otherwise). |
Result Set Columns
| Name | Type | Description |
| AffectedTables | String | Indicates the number of tables created. Returns '1' if the schema was successfully created, otherwise '0'. |