This topic describes the operations that you can perform when you use Tablestore SDK for Java to execute SQL statements.

Notice Tablestore SDK for Java V5.13.0 or later supports the SQL query feature. Before you use the SQL query feature, make sure that Tablestore SDK for Java V5.13.0 or later is obtained. For more information about the version history of Tablestore SDK for Java, see Tablestore SDK for Java.
Operation Description
Create tables and mapping tables Execute the create table statement to create tables and mapping tables. If a table with the specified name exists, only the mapping table is created. If a table with the specified name does not exist, both the table and the mapping table are created.
Notice The create table statement creates mapping tables for existing tables but cannot create tables.
Delete mapping tables Execute the drop mapping table statement to delete mapping tables.
List the names of tables Execute the show tables statement to query the names of tables in the current database.
Query information about tables Execute the describe statement to query the information about tables, such as the field names and field types.
Query the index information about tables Execute the show index statement to query the index information about tables.
Query data in tables Execute the select statement to query data in tables.