Show Views

The show views command displays all of the views in the current or specified schema.

Syntax

SHOW VIEWS [ IN schemaName ] 

schemaName

If you supply a schema name, only the views in that schema are displayed; otherwise, the views in the current schema are displayed.

Results

The show views command results contains the following columns:

Column Name Description
TABLE_SCHEMA The name of the table's schema
TABLE_NAME The name of the table
CONGLOM_ID The conglomerate number, which points to the corresponding table in HBase
REMARKS Any remarks associated with the table

Examples

splice> show views;
TABLE_SCHEM  |TABLE_NAME         |CONGLOM_ID|REMARKS
---------------------------------------------------------------
SPLICE       |GUITAR_BRANDS      |4321      |
0 rows selected