Help Center/ Data Lake Insight/ SQL Syntax Reference (Kuala Lumpur Region)/ Spark SQL Syntax Reference/ Viewing Tables/ Viewing All Columns in a Specified Table
Updated on 2023-03-06 GMT+08:00
View PDF
Share

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

  • COLUMNS: columns in the current table
  • FROM/IN: followed by the name of a database whose tables and views will be displayed. Keyword FROM is equivalent to IN. You can use either of them in a statement.

Parameters

Table 1 Parameter description

Parameter

Description

table_name

Table name

db_name

Database name

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