DESCRIBE
Description
The DESCRIBE statement displays metadata about a table, such as the column names and their data types.
Syntax
bash
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.
[db_name.]<table_name>
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.
Output
Without the Formatted option
| ColumnName | description |
|---|---|
| Name | Column Name |
| type | Column type |
| source | the formula of the column when the column is a computed column / calculated field |
| comment |
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.