SHOW TABLES
Summary
The SHOW TABLES command returns a result set containing metadata for all tables found in the Connect environment.
Syntax
show tables; |
Parameters
None.
Details
The SHOW TABLES result set includes the following columns. The metadata returned by the command is managed by Connect and cannot be directly altered by end users.
|
Column Name
|
Data Type
|
Description
|
|---|---|---|
| id | string | Unique identifier for table |
| schema_id | string | Unique identifier for schema |
| schema_name | string | Name of the table’s schema. Refer to SHOW SCHEMAS for more information about the schemas found in Connect. |
| name | string | Name of the table |
| description | string | For future use |
| type | string | Type of Connect object |
| created_by | string | Incent username who created the table. Connect creates tables in the xactly, staging, and xdms schemas upon first login into the system and during some product maintenance periods. |
| created_instant | instant | UTC instant when the table was created in Connect |
| modified_by | string | Incent username who altered the table |
| modified_instant | instant | UTC instant when the table was modified in Connect |
Examples
show tables;
select schema_name,
name
from (show tables)
where schema_name = ‘delta’;
