The system keeps a small table of global variables, initialized upon system restart, session restart, or declared explicitly by the user.
sys.environment
| name | type | references | description |
|---|---|---|---|
| "name" | VARCHAR | The unique identifying name of the global environment variable, such as monet_version and monet_release. | |
| "value" | VARCHAR | The value (as string) for the environment variable of the current instance of MonetDB. |
sys.var
| name | type | references | description |
|---|---|---|---|
| "schema" | VARCHAR | The schema in which the session variable is created | |
| "name" | VARCHAR | The declared name for the variable. The combination of schema and name uniquely identifies a specific variable. | |
| "type" | VARCHAR | The data type of the variable. | |
| "value" | VARCHAR | The value (as string) for the variable in the current session. |
sys.var_values
| name | type | references | description |
|---|---|---|---|
| "var_name" | VARCHAR | The unique identifying name of the system session variable, such as current_schema, optimizer or last_id. | |
| "value" | VARCHAR | The value (as string) for the system variable of the current session. |
sys.keywords
| name | type | references | description |
|---|---|---|---|
| "keyword" | VARCHAR | The reserved SQL keyword. |