Show Views

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


SHOW VIEWS [ IN schemaName ] 


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


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


splice> show views;
SPLICE       |GUITAR_BRANDS      |4321      |
0 rows selected