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;