All Products
Search
Document Center

Tablestore:Overview

Last Updated:Sep 05, 2023

This topic describes the operations that you can perform by executing SQL statements in Tablestore SDK for Go.

Important

The latest version of Tablestore SDK for Go supports the SQL query feature. Before you use the SQL query feature, make sure that the latest version of Tablestore SDK for Go is installed.

Operation

Description

Create mapping tables

You can execute the CREATE TABLE statement to create a mapping table for an existing data table or search index.

Delete mapping tables

You can execute the DROP MAPPING TABLE statement to delete mapping tables that are created for tables.

List the names of tables

You can execute the SHOW TABLES statement to list the names of tables in the current database.

Query information about tables

You can execute the DESCRIBE statement to query the information about tables, such as the field names and field types.

Query index information about tables

You can execute the SHOW INDEX statement to query the index information about tables.

Query data

You can execute the SELECT statement to query data in a table.

After an SQL statement returns the datetime data, date data, and time data, you can call corresponding API operations to query the data based on your requirements. For more information, see Query the date and time data.