SHOW TABLES statement
Shows the list of FeatureBase tables that exist on the server.
BNF diagram
Syntax
SHOW TABLES [WITH SYSTEM];
Arguments
Argument | Description |
---|---|
SHOW TABLES | Return all tables owned by the user |
WITH SYSTEM | Include FeatureBase system tables in results |
Returns
Column Name | Data type | Description | Further information |
---|---|---|---|
_id | id or string | Table ID | _id column |
name | string | Name of the table | naming standards |
owner | string | Owner of table (omitted for system-created sample data) | |
updated_by | string | Last user to update table | |
created_at | timestamp | Table time-date created | TIMESTAMP() data type |
updated_at | timestamp | Table time-date last updated | TIMESTAMP() data type |
keys | bool | Boolean that is true when keys are used (_id) is a string | |
space_used | int | bytes used by the table. | |
description | string | description COMMENT of the table |
Additional information
_id
column
The table ID column (_id
) is used as the table primary key and must uniquely represent a record in your table.
UI Type | SQL data type | Data source table unique key |
---|---|---|
Number | id | Positive integer |
String | string | String key or a combination of columns used to create a unique key |
Naming standards
FeatureBase identifiers (including object names such as databases, tables and columns) start with a lower-case alphabetic character and can include:
- lower-case alphabetic characters
- numbers 0-9
-
dash
-
and underscore_
characters. -
table names can be up to 230 characters in length
- column names can be up to 64 characters in length
Examples
Show your tables
SHOW TABLES;
Results:
_id | name | owner | updated_by | created_at | updated_at | keys | space_used | description
-------------------------+-------------------------+-------+------------+---------------------------+---------------------------+-------+-------------+------------------------------------
skills | skills | | | 1969-12-31T18:00:00-06:00 | 1969-12-31T18:00:00-06:00 | true | 37998707 |
Show your tables and system tables
SHOW TABLES WITH SYSTEM;
Results:
_id | name | owner | updated_by | created_at | updated_at | keys | space_used | description
-------------------------+-------------------------+-------+------------+---------------------------+---------------------------+-------+-------------+------------------------------------
fb_database_info | fb_database_info | | | 1969-12-31T18:00:00-06:00 | 1969-12-31T18:00:00-06:00 | false | 0 |
fb_database_nodes | fb_database_nodes | | | 1969-12-31T18:00:00-06:00 | 1969-12-31T18:00:00-06:00 | false | 0 |
fb_exec_requests | fb_exec_requests | | | 1969-12-31T18:00:00-06:00 | 1969-12-31T18:00:00-06:00 | false | 0 |
fb_performance_counters | fb_performance_counters | | | 1969-12-31T18:00:00-06:00 | 1969-12-31T18:00:00-06:00 | false | 0 |
fb_table_ddl | fb_table_ddl | | | 1969-12-31T18:00:00-06:00 | 1969-12-31T18:00:00-06:00 | false | 0 |
fb_views | fb_views | | | 1969-12-31T18:00:00-06:00 | 1969-12-31T18:00:00-06:00 | true | 8642560 | system table for views
skills | skills | | | 1969-12-31T18:00:00-06:00 | 1969-12-31T18:00:00-06:00 | true | 37998707 |