SQL query
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.
Features
|
Operation |
Description |
|
Use a CREATE TABLE statement to create a mapping table for an existing table or index. |
|
|
Use an ALTER TABLE statement to add or remove attribute columns of an existing mapping table. |
|
|
Use a DROP MAPPING TABLE statement to delete a mapping table. |
|
|
Use a SHOW TABLES statement to query the names of mapping tables in the current database. |
|
|
Use a DESCRIBE statement to query the information about a table, such as the field names and field types. |
|
|
Use a SHOW INDEX statement to query the index information about a table. |
|
|
Use a SELECT statement to query data in a table. |