Skip to main content

SHOW

SHOW COLUMNS​

Retrieve column information of a table.

Overview​

show columns from table [ like pattern ]

Parameters​

[ like pattern ]​
  • Use the like clause to filter results by pattern.
Example​
show columns statement example
-- Show only columns whose name ends with key
show columns from nation like '%key';

SHOW CREATE SCHEMA​

Retrieve the DDL of a schema (database).

Overview​

show create schema schema_name

SHOW CREATE TABLE​

Retrieve the DDL of a table.

Overview​

show create table table_name

SHOW FUNCTIONS​

Retrieve information about available functions.

Overview​

show functions [ like pattern ]

Parameters​

[ like pattern ]​
  • Use the like clause to filter results by pattern.

Example​

show functions statement example
-- Show only functions starting with array
show functions like 'array%';

SHOW SCHEMAS​

Retrieve the list of schemas (databases) in the specified datasource.

Overview​

show schemas [ from datasource ] [ like pattern ]

Parameters​

[ like pattern ]​
  • Use the like clause to filter results by pattern.

SHOW STATS​

Retrieve approximate statistics for a table or query.

caution

Values are approximate estimates and may not be exact.
If statistics are missing or unavailable, values may be NULL or empty.

Overview​

show stats for table
show stats for ( query )

SHOW TABLES​

Retrieve the list of tables in the specified schema (database).

Overview​

show tables [ from schema ] [ like pattern ]

Parameters​

[ like pattern ]​
  • Use the like clause to filter results by pattern.