Page Comparison

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 CUBES FROM <select-statement>
SHOW ADAPTIVE CACHE ACTIVE
SHOW ROLES
SHOW CURRENT ROLES
SHOW ROLES GRANT GROUP group_name
SHOW GRANT ROLE role_name
SHOW GRANT ON [ALL | SCHEMA schema_name | TABLE [schema_name.]table_name | VIEW view_name]
SHOW LDAP GROUPS
SHOW EXTERNAL DATA SOURCE[S]
SHOW EXTERNAL TABLES

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 CUBES {WITH WHERE <where-clause>} FROM <select-statement> - Lists all existing and potentials cubes for a given query.
• SHOW ADAPTIVE CACHE – Shows all adaptive cache entries.
• SHOW ROLES - Shows all available roles. 
  
• SHOW CURRENT ROLES - Shows only the roles applied for the current user.
  
• SHOW ROLES GRANT <group-name> - Shows all the roles, for a specific group.
  
• SHOW ROLES GRANT GROUPS - Shows all the roles, for all the groups.
  
• SHOW GRANT ROLE <role-name> - Lists the permissions that were granted to a specified role.
  
• SHOW GRANT ON {<object> | ALL} - Shows the roles and permissions which are granted to an object (SCHEMA/TABLE/VIEW name). The command: “SHOW GRANT ON ALL” will show all the roles and permissions for all of the objects of the current instance.
  
• SHOW LDAP GROUPS - Shows all the groups which are defined in the LDAP.
  
• SHOW EXTERNAL DATA SOURCE <external-ds-name> SPEC - Shows the data source name, type and location for a given external data source name.
  
• SHOW EXTERNAL DATA SOURCES - Shows the data source name, type and location for all existing external data sources.
  
• SHOW EXTERNAL TABLES - Shows the table name, data source name, and data source type, for existing all external tables.