Show

Show Databases

SHOW (DATABASES|SCHEMAS) [LIKE 'identifier_with_wildcards'];

 

Show Tables/Views/Materialized Views/Partitions

-- Show Tables
SHOW TABLES [IN database_name] ['identifier_with_wildcards'];

-- Show Views
SHOW VIEWS [IN/FROM database_name] [LIKE 'pattern_with_wildcards'];

-- Show Materialized Views
SHOW MATERIALIZED VIEWS [IN/FROM database_name] [LIKE 'pattern_with_wildcards'];

-- Show Partitions
SHOW PARTITIONS [db_name.]table_name [PARTITION(partition_spec)];

-- Show Table/Partition Extended
SHOW TABLE EXTENDED [IN|FROM database_name] LIKE 'identifier_with_wildcards' [PARTITION(partition_spec)];

 

Show Columns

SHOW COLUMNS (FROM|IN) table_name [(FROM|IN) db_name];