DESCRIBE statements

You can view the metadata for a table by using the DESCRIBE statement. The syntax is as follows:

DESCRIBE database.table

where table contains the table name. The describe statement returns the column names and data types for the table.