The SQL library is one of the key features of DTM SQL editor. It is a collection of SQL scripts, statements or even fragments of the statements. This collection has hierarchical structure and integrated to DTM SQL editor and a few other database utilities by DTM soft like DTM DB Stress.
Physically the library stored as a set of .SQL files in the location provided by the user. By default, it is library subfolder of DTM SQL editor installation. The user can move the library with operating system tools (like Windows Explorer) and change a path to the library in the product's settings. Of course, the library back up will be created automatically by system process if the user configured his or her data to back up.
There are two useful locations of the SQL Library: locally and on the shared network drive. The first case is suitable for the individual library when the second one is perfect for the team.
Due to static database structure all users, administrators, and developers select data from the same set of tables. Most popular queries are executed again and again by same or different users with or even without variations. Another idea is to store database-specific versions of most useful scripts at library's subtree.
If mentioned query or part of the query is stored in SQL Library, any DTM SQL editor user can insert it to the editor by 2-3 clicks. We recommend to add to the library following items: