tencent cloud

DokumentasiData Lake Compute

SHOW VIEWS

Download
Mode fokus
Ukuran font
Terakhir diperbarui: 2024-08-07 17:22:25

Description

Supported engines: Presto and SparkSQL
Purpose: List views in the specified database. If the database name is not specified, views in the current database are listed.

Statement

SHOW VIEWS [IN database_name] LIKE ['regular_expression']

Parameter

[IN database_name]: Name of the database whose views are to be listed. If this parameter is left blank, the database in the current context is selected.
regular_expression: Regular expression for filtering matching views Only the wildcard character * representing any character or expressions representing spaces or special characters between normal characters can be used.

Example

SHOW VIEWS;

SHOW VIEWS IN db01 LIKE 'view*';




Bantuan dan Dukungan

Apakah halaman ini membantu?

masukan