SQL query

Updated at:

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

Create a mapping table

Use a CREATE TABLE statement to create a mapping table for an existing table or index.

Update attribute columns of a mapping table

Use an ALTER TABLE statement to add or remove attribute columns of an existing mapping table.

Delete a mapping table

Use a DROP MAPPING TABLE statement to delete a mapping table.

Query the names of mapping tables

Use a SHOW TABLES statement to query the names of mapping tables in the current database.

Query information about a table

Use a DESCRIBE statement to query the information about a table, such as the field names and field types.

Query index information about a table

Use a SHOW INDEX statement to query the index information about a table.

Query data

Use a SELECT statement to query data in a table.