SHOW COLUMNS

Applies to: check marked yes Databricks SQL Databricks Runtime

Returns the list of columns in a table. If the table does not exist, an exception is thrown.

Syntax

SHOW COLUMNS { IN | FROM } table_name [ { IN | FROM } schema_name ]

Note

Keywords IN and FROM are interchangeable.

Parameters

table_name

Identifies the table. The name must not include a temporal specification or options specification.
schema_name

An optional alternative means of qualifying the table_name with a schema name. When this parameter is specified then table name should not be qualified with a different schema name.

Examples

-- Create `customer` table in the `salessc` schema;
> USE SCHEMA salessc;
> CREATE TABLE customer(
    cust_cd INT,
    name VARCHAR(100),
    cust_addr STRING);

-- List the columns of `customer` table in current schema.
> SHOW COLUMNS IN customer;
  col_name
 ---------
   cust_cd
      name
 cust_addr

-- List the columns of `customer` table in `salessc` schema.
> SHOW COLUMNS IN salessc.customer;
  col_name
 ---------
   cust_cd
      name
 cust_addr

-- List the columns of `customer` table in `salesdb` schema
> SHOW COLUMNS IN customer IN salessc;
  col_name
 ---------
   cust_cd
      name
 cust_addr