Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 



SHOW TABLES Statement

Description

Displays the list of all the table names within a database. The name of the result column will be tables_in_<database name> and it will have one column. If you use the LIKE clause, you can search the table names matching this and if you use the WHERE clause, you can search table names with more general terms. SHOW FULL TABLES displays the second column, table_type together. The table must have the value, BASE TABLE and the view has the value, VIEW.

Syntax

SHOW [FULL] TABLES [LIKE 'pattern' | WHERE expr]

Example

The following is the result of executing the query with the demodb.

SHOW TABLES;

  Tables_in_demodb

======================

  'athlete'

  'code'

  'event'

  'game'

  'history'

  'nation'

  'olympic'

  'participant'

  'record'

  'stadium'

 

SHOW FULL TABLES;

  Tables_in_demodb     Table_type

============================================

  'athlete'             'BASE TABLE'

  'code'                'BASE TABLE'

  'event'               'BASE TABLE'

  'game'                'BASE TABLE'

  'history'             'BASE TABLE'

  'nation'              'BASE TABLE'

  'olympic'             'BASE TABLE'

  'participant'         'BASE TABLE'

  'record'              'BASE TABLE'

  'stadium'             'BASE TABLE'

 

SHOW FULL TABLES LIKE '%c%';

  Tables_in_demodb      Table_type

============================================

  'code'                'BASE TABLE'

  'olympic'             'BASE TABLE'

  'participant'         'BASE TABLE'

  'record'              'BASE TABLE'

 

SHOW FULL TABLES  WHERE table_type = 'BASE TABLE' and TABLES_IN_demodb LIKE '%co%';   Tables_in_demodb      Table_type

============================================

  'code'                'BASE TABLE'

  'record'              'BASE TABLE'