SQL Library

The SQL Library is a perfect way to organize or share your SQL scripts. The SQL Library is a hierarchy of files and folders. You can add script to the library using Windows explorer. You can also save the script from DTM SQL editor into SQL library.

To access SQL Library click "SQL Library" button at the main query editor's page.

Default location of the library is "library" subdirectory in the product folder. For example, "C:\Program Files\DTM Query Reporter\Library". You can change this value using settings dialog.

The SQL script selected in the library can be saved using one of the following methods:

  • Insert - insert the file at the current cursor position.
  • Append - append the SQL file to the end of the script currently being edited.
  • Replace - replace the current script.

DTM Query Reporter: SQL library usage