All Products
Search
Document Center

Tablestore:Query information about tables

Last Updated:May 24, 2024

You can execute the DESCRIBE statement to query the information about a table, such as the field name and field type.

Syntax

DESCRIBE table_name;

Parameters

Parameter

Required

Description

table_name

Yes

The name of the table.

Examples

Query the information about a table named exampletable.

DESCRIBE exampletable;

The following figure shows an example of the query result.

image

References

  • You can execute the SELECT statement to query data based on the fields. For more information, see Query data.

  • To update the attribute column of the mapping table after the attribute column of the data table is changed, execute the ALTER TABLE statement. For more information, see Update attribute columns of mapping tables.