PATTERN_VARIABLES view

This Information Schema view displays a row for each pattern variable value, for all patterns which are added to the current project. The value of a pattern variable could be set individually for each instance folder, this is why there is one entry for each instance folder and pattern variable.

Columns

Column	Data Type	Description
PATTERN	string	The pattern to which the variable belongs
FOLDER	string	The path of an instance folder
NAME	string	The name of the pattern variable
VALUE	string	The value of the variable for the given instance folder

Examples

The following query retrieves all values of pattern variables.

SELECT * FROM @INFORMATION_SCHEMA.PATTERN_VARIABLES;

+-----------------+------------+--------------+------------+
| PATTERN         | FOLDER     | NAME         | VALUE      |
+-----------------+------------+--------------+------------+
| CORE_DATA_VAULT | /RAW_VAULT | SCHEMA_NAME  | CORE       |
| CORE_DATA_VAULT | /BDV       | SCHEMA_NAME  | BDV        |
+-----------------+------------+--------------+------------+