SHOW TABLES statement

Shows the list of FeatureBase tables that exist on the server.

BNF diagram

expr

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 |