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.
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.