TDV Adapter for MongoDB

Build 21.0.8137

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) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137