INSTANCES view

This Information Schema view displays a row for each instance that exists in the current project. The view will deliver the same instances that you see in the instances list in the sidebar.

Columns

Column	Data Type	Description
ID	integer	The unique ID of the instance
PATTERN	string	The pattern to which the instance belongs
FOLDER	string	The folder path to the instance
INSTANCE	string	The name of the instance
UPLOAD_ENABLED	integer	A flag indicating whether uploading new metadata to this instance is allowed
INSERT_ENABLED	integer	A flag indicating whether inserting new metadata via SQL is allowed
EDIT_ENABLED	integer	A flag indicating whether the user could edit the instance via the UI
BUILD_ENABLED	integer	A flag indicating whether this instance could be build
LATEST_BUILD_ID	integer	The ID of the latest build in which this instance was built
DELETED	integer	A flag indicating whether the instance is deleted (1) or not (0)
DESCRIPTION	string	The description of this instance

Examples

The following query retrieves a list of all instances inside the current project.

SELECT * FROM @INFORMATION_SCHEMA.INSTANCES;

+----+-----------------+------------+--------------+----------------+----------------+--------------+---------------+-----------------+---------+------------------------------+
| ID | PATTERN         | FOLDER     | INSTANCE     | UPLOAD_ENABLED | INSERT_ENABLED | EDIT_ENABLED | BUILD_ENABLED | LATEST_BUILD_ID | DELETED | DESCRIPTION                  |
+----+-----------------+------------+--------------+----------------+----------------+--------------+---------------+-----------------+---------+------------------------------+
| 25 | CORE_DATA_VAULT | /RAW_VAULT | ACCOUNT_HUB  | 1              | 1              | 1            | 1             | 4711            | 0       | The account hub              |
| 26 | CORE_DATA_VAULT | /RAW_VAULT | CUSTOMER_SAT | 1              | 0              | 1            | 1             | 4711            | 1       | null                         |
| 27 | LDG_FLAT_FILE   | /SRC_A     | Acc_obj_tbl  | 1              | 1              | 1            | 0             | 4713            | 0       | Used for account sat and hub |
| 28 | LDG_FLAT_FILE   | /SRC_B     | Partners     | 0              | 0              | 0            | 1             | 4714            | 0       | null                         |
+----+-----------------+------------+--------------+----------------+----------------+--------------+---------------+-----------------+---------+------------------------------+