Unlike the data definition language (DDL) operations that you can execute to perform operations on data tables in traditional relational databases, the DDL operations of Tablestore allow you to create mapping tables for existing data tables and search indexes and perform operations on and manage the mapping tables. This topic describes the DDL operations supported by Tablestore and the specific features of the DDL operations.
DDL operation | Feature | References |
CREATE TABLE | Create a mapping table for an existing table or search index. When you create a mapping table, specify the names and types of fields in the table, the primary key information about the table, and the execution engine that you want to use when you use the mapping table to query data based on your business requirements. | |
ALTER TABLE | Add or remove attribute columns in an existing mapping table. | |
DROP MAPPING TABLE | Delete one or more mapping tables by using a single request. | |
DESCRIBE | Query information about a mapping table, such as the field names and field types. |