Describe Table

Important

This documentation has been retired and might not be updated. The products, services, or technologies mentioned in this content are no longer supported. See DESCRIBE TABLE.

Describe Table (Delta Lake on Databricks)

DESCRIBE [EXTENDED] [db_name.]table_name

DESCRIBE [EXTENDED] delta.`<path-to-table>`

Return the metadata of an existing table (column names, data types, and comments). If the table does not exist, an exception is thrown.

EXTENDED

Display detailed information about the table, including parent database, table type, storage information, and properties.

Describe Partition (Delta Lake on Databricks)

DESCRIBE [EXTENDED] [db_name.]table_name PARTITION partition_spec

DESCRIBE [EXTENDED] delta.`<path-to-table>` PARTITION partition_spec

Return the metadata of a specified partition. The partition_spec must provide the values for all the partition columns.

EXTENDED

Display basic information about the table and the partition-specific storage information.

Describe Columns (Delta Lake on Databricks)

DESCRIBE [EXTENDED] [db_name.]table_name column_name

DESCRIBE [EXTENDED] delta.`<path-to-table>`

Return the metadata of a specified column.

EXTENDED

Display detailed information about the specified columns, including the column statistics collected by the command ANALYZE TABLE table_name COMPUTE STATISTICS FOR COLUMNS column_name [column_name, ...].

Describe Formatted (Delta Lake on Databricks)

DESCRIBE FORMATTED [db_name.]table_name

DESCRIBE FORMATTED delta.`<path-to-table>`

Return the table format.

Describe Detail (Delta Lake on Databricks)

DESCRIBE DETAIL [db_name.]table_name

DESCRIBE DETAIL delta.`<path-to-table>`

Return information about schema, partitioning, table size, and so on. For example, you can see the current reader and writer versions of a table.