DESCRIBE Statement

The DESCRIBE statement shows the schema of a table, view or query.

Usage

DESCRIBE tbl;

To describe a query, prepend DESCRIBE to a query.

DESCRIBE SELECT * FROM tbl;

Alias

The SHOW statement is an alias for DESCRIBE.

See Also

For more examples, see the guide on DESCRIBE.