SHOW Schemas/Tables/Views/Partitions/Functions

Function

SHOW is a syntax specific to DataArts Fabric SQL. This syntax is used to list sub-objects of a specified object in LakeFormation.

Precautions

None.

Syntax

1
2
3
4
5
6
7

SHOW SCHEMAS;
SHOW TABLES IN schema_name;
SHOW PARTITIONS table_name;
SHOW VIEWS;
SHOW VIEWS IN schema_name;
SHOW FUNCTIONS;
SHOW FUNCTIONS IN schema_name;

Parameter Description

None.

Examples

Lists all databases in the current catalog.

1

SHOW SCHEMAS;

List all tables in the test_schema database on LakeFormation.

1

SHOW TABLES IN test_schema;

List all partitions of the test_table table on LakeFormation.

1

SHOW PARTITIONS test_table;

List all views in the current database on LakeFormation.

1

SHOW VIEWS;

List all views in the test_schema database on LakeFormation.

1

SHOW VIEWS IN test_schema;

List all user-defined functions in the current database on LakeFormation.

1

SHOW FUNCTIONS;

List all functions in the test_schema database on LakeFormation.

1

SHOW FUNCTIONS IN test_schema;