Use SQL query by using Tablestore SDK for .NET - Tablestore

Tablestore SDK for .NET supports SQL query operations for creating, managing, and querying mapping tables.

Usage notes

SQL query is supported in Tablestore SDK for .NET V5.0.0 and later. Make sure that a supported SDK version is installed.

For more information, see Version history of Tablestore SDK for .NET.

Operation	Description
Create a mapping table	You can execute the `CREATE TABLE` statement to create a mapping table for an existing table or a search index.
Update attribute columns of a mapping table	You can execute the `ALTER TABLE` statement to add or remove attribute columns for an existing mapping table.
Delete a mapping table	You can execute the `DROP MAPPING TABLE` statement to delete mapping tables.
Query the names of mapping tables	You can execute the `SHOW TABLES` statement to query mapping tables in the current database.
Query information about a table	You can execute the `DESCRIBE` statement to query information about a table, such as the field names and field types.
Query index information about a table	You can execute the `SHOW INDEX` statement to query index information about a table.
Query data	You can execute the `SELECT` statement to query data in a table.