SHOW

Summary

The SHOW command returns a table result set that lists metadata for a specific kind of object.

Syntax

SHOW <object_type>;

Parameters

Parameter
Description
<object_type> The type of object, from among the following:

  • CATALOGS
  • SCHEMAS
  • TABLE
  • TABLES
  • TYPES
  • VARIABLES

Details

You can use this command to create a list of tables or show the column names and data types in a table.

Examples

SHOW CATALOGS;
SHOW SCHEMAS;
SHOW TABLES;
SHOW TABLE <schema_name.table_name>;
SHOW TYPES;
SHOW VARIABLES;
 
/* Alternative syntax using SELECT. Since the SHOW command returns a table, you can query the SHOW command similar to a regular database table. */
SELECT * FROM (SHOW TABLES);
SELECT schema_name, name FROM (SHOW TABLES);
SELECT schema_name, table_name, column_name, type, odbc_type_name FROM (SHOW TABLE xactly.xc_period);