Show Tables

The show tables command displays all of the tables in the current or specified schema.

schemaName

If you supply a schema name, only the tables in that schema are displayed; otherwise, the tables in the current schema are displayed.

Syntax

SHOW TABLES [ IN schemaName ] 

Results

The show tables command results contains the following columns:

Column Name Description
TABLE_SCHEMA The name of the table's schema
TABLE_NAME The name of the table
CONGLOM_ID The conglomerate number, which points to the corresponding table in HBase
REMARKS Any remarks associated with the table

Examples

splice> show tables;
TABLE_SCHEM  |TABLE_NAME         |CONGLOM_ID|REMARKS
------------------------------------------------------
SYS          |SYSALIASES         |352       |
SYS          |SYSBACKUP          |1040      |
SYS          |SYSBACKUPFILESET   |1056      |
SYS          |SYSBACKUPITEMS     |1136      |
SYS          |SYSBACKUPJOBS      |1200      |
SYS          |SYSCHECKS          |368       |
SYS          |SYSCOLPERMS        |704       |
SYS          |SYSCOLUMNS         |64        |
SYS          |SYSCOLUMNSTATS     |1216      |
SYS          |SYSCONGLOMERATES   |80        |
SYS          |SYSCONSTRAINTS     |320       |
SYS          |SYSDEPENDS         |240       |
SYS          |SYSFILES           |256       |
SYS          |SYSFOREIGNKEYS     |288       |
SYS          |SYSKEYS            |272       |
SYS          |SYSPERMS           |784       |
SYS          |SYSPHYSICALSTATS   |1232      |
SYS          |SYSPRIMARYKEYS     |384       |
SYS          |SYSROLES           |736       |
SYS          |SYSROUTINEPERMS    |720       |
SYS          |SYSSCHEMAPERMS     |1392      |
SYS          |SYSSCHEMAS         |32        |
SYS          |SYSSEQUENCES       |752       |
SYS          |SYSSTATEMENTS      |304       |
SYS          |SYSTABLEPERMS      |688       |
SYS          |SYSTABLES          |48        |
SYS          |SYSTABLESTATS      |1248      |
SYS          |SYSTRIGGERS        |656       |
SYS          |SYSUSERS           |816       |
SYS          |SYSVIEWS           |336       |
SYSIBM       |SYSDUMMY1          |1344      |
SPLICE       |MYTABLE            |1536      |

32 rows selected

splice>show tables in SPLICE;
TABLE_SCHEM  |TABLE_NAME         |CONGLOM_ID|REMARKS
-----------------------------------------------------
SPLICE       |MYTABLE            |1536      |

1 row selected