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;