ADO.NET Provider for MongoDB

Build 26.0.9655

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.
UserTableTempTable String The temporary table that contains all column metadata rows used to generate the schema definition.
ColumnName String The column name field expected in each metadata row of UserTableTempTable.
ColumnDataType String The SQL data type field expected in each metadata row of UserTableTempTable.
ColumnSize String The column size field expected in each metadata row of UserTableTempTable.
ColumnScale String The numeric scale field expected in each metadata row of UserTableTempTable.
ColumnIsKey String The primary key indicator field expected in each metadata row of UserTableTempTable ('true' for key columns, 'false' otherwise).
ColumnIsNull String The nullable indicator field expected in each metadata row of UserTableTempTable ('true' for nullable columns, 'false' otherwise).
ColumnDefault String The default value field expected in each metadata row of UserTableTempTable.
ColumnAutoIncrement String The auto-increment indicator field expected in each metadata row of UserTableTempTable ('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'.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655