Updated on 2023-03-30 GMT+08:00

Extension Constraints

IoT database warehouses support only some relational syntax.

Table 1 Supported syntax

Syntax

Supported or Not (Y/N)

CREATE TABLE

Y

CREATE TABLE LIKE

Y

DROP TABLE

Y

INSERT

Y

COPY

Y

SELECT

Y

TRUNCATE

Y

EXPLAIN

Y

ANALYZE

Y

VACUUM

Y

ALTER TABLE DROP PARTITION

Y

ALTER TABLE ADD PARTITION

Y

ALTER TABLE SET WITH OPTION

Y

ALTER TABLE DROP COLUMN

Y

ALTER TABLE ADD COLUMN

Y

ALTER TABLE ADD NODELIST

Y

ALTER TABLE CHANGE OWNER

Y

ALTER TABLE RENAME COLUMN

Y

ALTER TABLE TRUNCATE PARTITION

Y

CREATE INDEX

Y

DROP INDEX

Y

DELETE

Y

ALTER TABLE

N

ALTER INDEX

N

MERGE

N

SELECT INTO

Y

UPDATE

N

CREATE TABLE AS

N