Use Tablestore SQL query through Node.js SDK - Tablestore

This topic describes the SQL query operations that the Tablestore Node.js SDK supports.

Notes

Starting with version 5.2.0, the Tablestore Node.js SDK includes support for the SQL query feature. Ensure you have the correct version of the Node.js SDK installed to use this feature.

For more information, see the historical iterations of the Node.js SDK.

Feature list

Operation	Description
Create mapping table	Create a mapping relationship for an existing table or index by using the `CREATE TABLE` statement.
Update mapping table	Add or delete property columns for an existing mapping table by using the `ALTER TABLE` statement.
Delete mapping table	Delete a mapping relationship by using the `DROP MAPPING TABLE` statement.
List mapping tables	List the mapping tables in the current database by using the `SHOW TABLES` statement.
Query table description	Query the description of a table, such as field names and field types, by using the `DESCRIBE` statement.
Query index description	Query the description of a table's index by using the `SHOW INDEX` statement.
Query data	Query data in a table by using the `SELECT` statement.