Environment Variables

AQT has a window for viewing and updating Environment Variables. This was borne out of frustration with the ridiculously-bad means that Windows supplied for displaying and updating Environment Variables (though this has been improved in Windows 10 and Windows 11).

To show your environment variables, from the Database Explorer window, go to Tools > Environment Variables.

Three Sets of Environment Variables

There are three sets of environment variables:

Machine environment variables - these apply to all users on your machine
User environment variables - these apply to your userid only
Process environment variables. These are the environment variables in use for your current process. These are the combination of the machine and user environment variables.

You can use the options at the top of the window to select which of these to display.

Multi-item Environment Variables

Some environment variables, in particular PATH environment variables, consistent of multiple items separated by a semi-colon. AQT will split these out over multiple lines - this makes them much easier to view.

Show Full Value

Some environment variables, in particular PATH environment variables, can be quite large and the display will not show the full value. To see the full value, double-click a cell. You will be shown the full value in a popup-box.

Updating / Adding an Environment Variable

To do this, click on Show Update Panel.The Update Panel will allow you to update or add an environment variable.

Environment Variables 2

Notes:

To update a value, edit the value in the text box then click on Update or Create Value
For a multi-item value, enter the values separated on separate lines. Make sure you include the semi-colon add the end of each line - AQT will not add this for you.
To add a new environment variable, change the environment variable name to the new name then click on Update or Create Value
In general you will not be able to update or add Machine environment variables. If you wish to do this, you will need to start AQT with "Run as Administrator".

Advanced Query Tool

https://www.querytool.com