This topic describes the SQL statements that are supported by the Tablestore SQL engine.
SQL statement | Description | Supported |
CREATE TABLE | Creates a mapping table for an existing data table. | Yes |
Creates a mapping table for an existing search index. | Yes | |
ALTER TABLE | Adds or deletes an attribute column. | Yes |
SHOW TABLES | Lists the names of tables in the current database. | Yes |
SELECT | Queries data. | Yes |
DROP MAPPING TABLE | Deletes a mapping table. | Yes |
DROP TABLE | Deletes a data table. | Available soon |
CREATE INDEX | Creates an index. | No |
SHOW INDEX | Queries information about an index. | Yes |
INSERT | Writes data. | No |
SELECT JOIN | Performs a data query that joins multiple tables. | Yes |