CREATE clauses

CREATE

statements partially support

TABLE

and

INDEX

IMPORTANT:

CREATE

statements, including

TABLE

and

INDEX

, are not supported by the Influx database parser. Only explicit schema can be managed or modified using client API. For more information, see https://docs.influxdata.com/influxdb/cloud/admin/buckets/bucket-schema/.

Examples

CREATE UNIQUE INDEX Table_Index ON Table1 (Column1)

CREATE INDEX IF NOT EXISTS Table_Index ON Table1 (Column1)

CREATE TABLE TempTable AS SELECT Column1 FROM MyTable WHERE Column1 > 5

CREATE TEMPORARY TABLE TempTable AS SELECT Column1 FROM MyTable WHERE Column1 > 5

Provide Feedback

Have questions or feedback about this documentation? Please submit your feedback here.