SHOW COLUMNS
Applies to: 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
-
Identifies the table. The name must not include a temporal specification.
-
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