SHOW TABLES statement
Shows the list of FeatureBase tables that exist on the server.
BNF diagram
Syntax
SHOW TABLES;
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
Sample data has been loaded to a new FeatureBase database.
SHOW TABLES;
CSV results
_id,name,owner,updated_by,created_at,updated_at,keys,space_used,description
fb_views,fb_views,,,2023-01-18T06:05:23Z,2023-01-18T06:05:23Z,true,8642560,system table for views
skills,skills,,c9e4d4d2-bfee-4dae-8b1e-e172bf17b2d7,2023-01-05T05:53:06Z,2023-01-25T07:15:48Z,true,44331123,
fb_cluster_info,fb_cluster_info,,,1970-01-01T00:00:00Z,1970-01-01T00:00:00Z,false,0,
fb_cluster_nodes,fb_cluster_nodes,,,1970-01-01T00:00:00Z,1970-01-01T00:00:00Z,false,0,
fb_exec_requests,fb_exec_requests,,,1970-01-01T00:00:00Z,1970-01-01T00:00:00Z,false,0,
fb_table_ddl,fb_table_ddl,,,1970-01-01T00:00:00Z,1970-01-01T00:00:00Z,false,0,
fb_performance_counters,fb_performance_counters,,,1970-01-01T00:00:00Z,1970-01-01T00:00:00Z,false,0,