SHOW

Displays the metadata information of the instance.

Syntax

SHOW PARAM parameter_name | ALL 
SHOW TABLES [EXTENDED | MAINT]  [schema_name] 
SHOW TABLE COLUMNS | PARTITIONS [schema_name.]table_name 
SHOW VIEWS [EXTENDED] [schema_name] 
SHOW LOCAL CACHE
SHOW ACTIVE QUERIES 
SHOW SCHEMAS 
SHOW JOIN INDEXES
SHOW RANGE INDEXES 
SHOW SCHEDULED LOADS
SHOW VERSION 
SHOW CUBES 
SHOW ADAPTIVE CACHE ACTIVE

Description

Displays various aspects of the system. Some of the command options allow displaying detailed storage usage data, for example at the table, partition, or cache level. Displaying low-resolution storage usage data may take a while, as those commands analyze the current storage usage.

• SHOW PARAM – Displays the current value of a specific system parameter, or all Output specifies set value and set level using "*" sign.
• SHOW TABLES – Lists all tables in the instance.
• SHOW TABLES EXTENDED – Lists all tables with more detailed information, including number of columns, number of rows, number of partitions, and size on disk.
• SHOW TABLES MAINT – Lists the background maintenance status of all tables.
• SHOW TABLE COLUMNS – Lists all columns of a table, including number of distinct values, number of NULLs and size on disk.
• SHOW TABLE PARTITIONS – Lists all partitions of a partitioned table, including partition boundaries, number of rows, and size on disk.
• SHOW VIEWS [EXTENDED] – Lists all views in the instance or in a specific schema. When specifying EXTENDED, also lists the view status (valid/invalid) and underlying SQL statement.
• SHOW LOCAL CACHE – Lists the contents of the local cache – a summary per table.
• SHOW ACTIVE QUERIES – Lists all in-progress queries (running or queued).
• SHOW SCHEMAS – Lists all schemas defined in the Currently it is not possible to add new schemas to the default schema.
• SHOW JOIN INDEXES – Lists all existing join indexes and their attributes.
• SHOW RANGE INDEXES – Lists all existing range indexes and their attributes.
• SHOW SCHEDULED LOADS - Displays all scheduled loads.
• SHOW VERSION – Shows the server's version number.
• SHOW CUBES – Displays all generated cubes.
• SHOW ADAPTIVE CACHE – Shows all adaptive cache entries.