COLUMNS view

This Information Schema view displays a row for each column in the tables and views defined in the meta database of your selected project.

See also

• TABLES view

Columns

Column	Data Type	Description
ID	integer	The unique ID of the column
TABLE_FOLDER	string	The folder path to the table
TABLE_NAME	string	The name of the table or view to which this columns belongs
COLUMN_NAME	string	The name of the column
ORDINAL_POSITION	integer	The position of the column within the set of columns
DATA_TYPE	string	The data type of this column
CREATED	timestamp	The time of creation of this column
DESCRIPTION	string	The column description

Examples

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

SELECT * FROM @INFORMATION_SCHEMA.COLUMNS;

+-----+--------------+-----------------+-------------+------------------+-----------+---------------------+-------------+
| ID  | TABLE_FOLDER | TABLE_NAME      | COLUMN_NAME | ORDINAL_POSITION | DATA_TYPE | CREATED             | DESCRIPTION |
+-----+--------------+-----------------+-------------+------------------+-----------+---------------------+-------------+
| 311 | /my_scope    | MKW_VAULT_SCOPE | SCOPE       | 0                | string    | 2023-08-25 17:11:46 |             |
| 313 | /my_scope    | MKW_VAULT_SCOPE | SRC_OBJECT  | 1                | string    | 2023-08-25 17:11:46 |             |
| 314 | /my_scope    | MKW_VAULT_SCOPE | ENTITY_NAME | 2                | string    | 2023-08-25 17:18:27 |             |
| 316 | /my_scope    | MKW_VAULT_SCOPE | OBJECT_TYPE | 3                | string    | 2023-08-25 19:23:35 |             |
| 394 | /md_prep     | MKW_KEYS        | KEY_TYPE    | 1                | string    | 2023-08-26 13:31:37 |             |
| 401 | /md_prep     | MKW_KEYS        | FIELD_NAME  | 2                | string    | 2023-08-26 13:31:37 |             |
+-----+--------------+-----------------+-------------+------------------+-----------+---------------------+-------------+