TABLES view

This Information Schema view displays a row for each table or view defined in the meta database of your selected project.

See also

• COLUMNS view

Columns

Column	Data Type	Description
ID	integer	The unique ID of the table
TABLE_FOLDER	string	The folder path to the table
TABLE_NAME	string	The name of the table or view
TABLE_TYPE	string	The type of this table (TABLE, VIEW, EXTERNAL_TABLE)
CREATED	timestamp	The time of creation of this table
DESCRIPTION	string	The description of the table

Examples

The following query retrieves all tables/views in the current project.

SELECT * FROM @INFORMATION_SCHEMA.TABLES;

+-----+--------------+-----------------+------------+---------------------+-------------+
| ID  | TABLE_FOLDER | TABLE_NAME      | TABLE_TYPE | CREATED             | DESCRIPTION |
+-----+--------------+-----------------+------------+---------------------+-------------+
| 311 | /my_scope    | MKW_VAULT_SCOPE | TABLE      | 2023-08-25 17:11:46 |             |
| 401 | /md_prep     | MKW_KEYS        | VIEW       | 2023-08-26 13:31:37 |             |
+-----+--------------+-----------------+------------+---------------------+-------------+