SHOW COLUMNS
Shows the column names for a specified table or view. To view additional column metadata
(such as data type), see Listing or searching columns for
a specified table or view. To view all columns for all
tables in all databases in AwsDataCatalog or for all tables in a specific
database in AwsDataCatalog, see Listing all
columns for all tables in the Querying AWS Glue Data Catalog topic.
Synopsis
SHOW COLUMNS (FROM|IN) database_name.table_nameSHOW COLUMNS (FROM|IN) table_name [(FROM|IN) database_name]The FROM and IN keywords can be used interchangeably. If
table_name or database_name
has special characters like hyphens, surround the name with backquotes (for example,
`my-database`.`my-table`). Do not surround the
table_name or database_name
with single or double quotes. Currently, the use of LIKE and pattern
matching expressions is not supported.
Examples
The following equivalent examples show the columns from the orders table
in the customers database. The first two examples assume that
customers is the current database.
SHOW COLUMNS FROM orders
SHOW COLUMNS IN orders
SHOW COLUMNS FROM customers.orders
SHOW COLUMNS IN customers.orders
SHOW COLUMNS FROM orders FROM customers
SHOW COLUMNS IN orders IN customers
