Using the Files Tab
A script is a file with one or more SQL statements that you can edit and execute in an SQL Commander tab. Scripts may be kept anywhere in the file system and loaded into SQL Commander when needed, but using the Files tab makes it easier to organize and access your scripts.
Mounting folders
The Files tab gives you quick access to file system folders of your choice. Adding a relevant folder to the Files tab is called mounting. To mount a folder, drag and drop it from the file system to an empty area in the Files tab, or use the corresponding menu action to choose the folder to mount.
Mounted folders can be rearranged using drag and drop in the Files tab.
You can choose an arbitrary display name for your mounted folders. To do so, right-click on the folder and choose Rename. In addition to the display name, the folder's actual path is displayed within square brackets.
Pre-mounted folders
By default, the Files tab contains three pre-mounted locations.
Bookmarks is a pre-defined location for scripts stored within the DbVisualizer file structure. See Managing Frequently Used SQL for more details.
Monitors contains monitored queries in DbVisualizer. See Monitoring Data Changes for more information.
User's home directory is also pre-mounted for your convenience.
You can remove and add them back using the toolbar, and add your own folders by mounting them in addition to or instead of the default locations.
Expanded state
For convenience, any currently expanded folders will be re-expanded upon the next start of DbVisualizer.
Working with files
When expanded, the contents of the folder will be displayed including any subfolders and files. Double-click or use the context menu to open a file in SQL Commander.
Use the toolbar or the context menu to create new files and folders or rename existing ones. To move files and folders, use drag and drop. To copy, use drag and drop with a modifier key or the corresponding keyboard shortcuts. There's also a handy context menu action for duplicating a file.
To delete a file or a folder, use the Delete action in the context menu. If supported on your operating system, this will move the corresponding file to the recycle bin.
Reloading the tree
When possible, the nodes in the tree are kept in sync with the file system by monitoring changes in the corresponding physical locations. For example, if a new file has been created in an expanded folder outside DbVisualizer, it will appear in the tree automatically.
In situations when the tree gets out of sync, a manual reload of either selected nodes or the whole tree can be triggered using the toolbar.
Choosing what to see
By default, the Files tab shows all file types but doesn't include hidden files. This can be changed using the corresponding toolbar options. In particular, Show Scripts Only will hide non-script files from the tree. The Settings... action will open the corresponding section in Tool Properties where you can choose which file extensions will be considered to be scripts.
Quick search
The quick search field can be used to find matching entries in the tree. As usual, pressing on the magnifying glass icon will bring up the menu with advanced search options.
Please note that quick search only affects those parts of the tree that have already been loaded. Bookmarks and Monitors are fully searchable from the start, but other folders are only searchable in those parts that have been expanded since the last reload.
The details section
When activated in the toolbar, a details section will be displayed in the bottom part of the Files tab displaying information about the currently selected item.
Among other things, DbVisualizer keeps track of the latest used connection, catalog and schema for script files. This information is also accessible in the details section.
