Skip to main content
Skip table of contents



The DESCRIBE statement displays metadata about a table, such as the column names and their data types.



DESCRIBE [FORMATTED] [db_name.]<table_name>

You can use the abbreviation DESC for the DESCRIBE statement.

If you have the SELECT privilege on a subset of the table columns and no other relevant table privileges, DESCRIBE returns the data from the columns you have access to.


table name.

By default, the table is assumed to be in the current database. Use a fully qualified table name to specify a table in any database.


Without the Formatted option

NameColumn Name
typeColumn type
sourcethe formula of the column when the column is a computed column / calculated field

With the Formatted option

Even if the Formatted option is available, the output is of no use since there is no more useful information than the output information without the option.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.