Description
SHOW COLUMNS is a SQL command used to view column information in a table. With this command, users can quickly obtain the column names and data types of a table.
Syntax
SHOW COLUMNS
[ IN | FROM ] -- Use the IN or FROM keyword
[<schema_name>.]<table_name> -- Table name with optional Schema prefix
[IN <schema_name>] -- Separated Schema and table name
Parameter Details
Core Parameters
| Parameter Format | Required | Description |
|---|
<table_name> | Required | The name of the target table |
<schema_name> | Optional | Schema name, supported in two forms:
1. As a table name prefix: schema.table
2. Via the IN clause |
Usage Guidelines
Schema Specification Methods (choose one)
-- Method 1: Schema and table name combined
SHOW COLUMNS IN sales.orders;
-- Method 2: Schema and table name separated
SHOW COLUMNS FROM orders IN sales;
Invalid Usage Examples
-- Error! Schema specified twice
SHOW COLUMNS IN sales.orders IN sales;
-- Error! Mixing the two syntax forms
SHOW COLUMNS FROM sales.orders IN production;
Usage Examples
View column information of a table in the current schema:
SHOW COLUMNS IN household_demographics;
+-------------+------------------------+-------------------+-----------+---------+
| schema_name | table_name | column_name | data_type | comment |
+-------------+------------------------+-------------------+-----------+---------+
| tpcds_10tb | household_demographics | hd_demo_sk | int | |
| tpcds_10tb | household_demographics | hd_income_band_sk | int | |
| tpcds_10tb | household_demographics | hd_buy_potential | string | |
| tpcds_10tb | household_demographics | hd_dep_count | int | |
| tpcds_10tb | household_demographics | hd_vehicle_count | int | |
+-------------+------------------------+-------------------+-----------+---------+
FAQ
Q1: How to view detailed information about a table (such as table structure)?
Q2: Does SHOW COLUMNS support filtering conditions?
