Switch to: V9V8V7V6V5

SHOW TABLES

SHOW TABLES statement lists non-TEMPORARY tables and views of a database.

Syntax

SHOW TABLES [{FROM|OF} db_name] 

Examples

SHOW TABLES
-- this query selects only TABLEs but not VIEWs.
SELECT * FROM (SHOW TABLES) WHERE type = 'TABLE'

Result Columns

fld_type

The of record it can be table or view.

fld_name

The name of table or view.

fld_id

The unique ID of table.

fld_locale

The table locale.

fld_encoding

The table storage encoding.

fld_field_count

The count of fields in the current table.

fld_link_count

The count of links in the current table.

fld_record_count

The count of records in the current table.

fld_text

The SQL command which is was used for create table.

fld_kind

The table kind ID.

fld_kind_str

The table kind. It can be “USER” table or “INTERNAL_TMP” table.

fld_storage_type

Where the table is placed. It can be “DISK” or “RAM”