CData Python Connector for MongoDB

Build 24.0.9060

CREATE TABLE Statements

To create new MongoDB entities, use CREATE TABLE statements.

CREATE TABLE Syntax

The CREATE TABLE statement specifies the table name and a comma-separated list of column names and the primary keys of the table, as shown in the following example:

CREATE TABLE <table_name> [ IF [ NOT EXISTS ] ]
( 
  { 
     <column_name> <data_type> 
     [ NOT NULL ] 
     [ DEFAULT <literal> ] 
     [ PRIMARY KEY ] 
     [ UNIQUE ] 
  } |  PRIMARY KEY ( <column_name> [ , ... ] ) 
  [ , ... ]
)

The following example statement creates a MyCustomers table on the MongoDB server with name, age, and address columns:

CREATE TABLE IF NOT EXISTS [MyCustomers] (name VARCHAR(20), age INT, address VARCHAR(20))

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060