Table of Contents
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”