Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

SHOW COLUMNS

Focus mode

On this page

SHOW COLUMNS - Amazon Athena

Shows only the column names for a single specified table, Athena view, or Data Catalog view. To obtain more detailed information for Athena views, query the AWS Glue Data Catalog instead. For information and examples, see the following sections of the Query the AWS Glue Data Catalog topic:

For Data Catalog views, the output of the statement is controlled by Lake Formation access control and shows only the columns that the caller has access to.

Synopsis

SHOW COLUMNS {FROM|IN} database_name.table_or_view_name
SHOW COLUMNS {FROM|IN} table_or_view_name [{FROM|IN} database_name]

The FROM and IN keywords can be used interchangeably. If table_or_view_name or database_name has special characters like hyphens, surround the name with back quotes (for example, `my-database`.`my-table`). Do not surround the table_or_view_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
PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.