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.
sql
SELECT * FROM @INFORMATION_SCHEMA.INSTANCES;txt
+----+-----------------+------------+--------------+----------------+----------------+--------------+---------------+-----------------+---------+------------------------------+
| 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 |
+----+-----------------+------------+--------------+----------------+----------------+--------------+---------------+-----------------+---------+------------------------------+