Help Center> Data Lake Insight> SQL Syntax Reference> SQL Syntax of Batch Jobs> Viewing Tables> Viewing All Columns in a Specified Table
View PDF

Viewing All Columns in a Specified Table

Function

This statement is used to query all columns in a specified table.

Syntax

1
 
SHOW COLUMNS {FROM | IN} table_name [{FROM | IN} db_name];

Keyword

FROM/IN: Displays the column names of tables in a specified database. Keyword FROM is equivalent to IN. You can use either of them in the statement.

Precautions

The specified table must exist in the database. If the table does not exist, an error is reported.

Example

Run the following statement to view all columns in the student table.

1
 
SHOW COLUMNS IN student;
Parent topic: Viewing Tables