Administration and Customization > Database Administration
From the SQL window, administrator users can execute SQL commands on the databases directly from MassTrack. To open the SQL window, select Database > Query > Project Database. SQL commands can be executed either on the historical database or the current project database.
WARNING: INCORRECT USE OF SQL COMMANDS ON THE DATABASES MAY DESTROY THE DATABASES, CAUSE LOSS OF DATA OR PREVENT MassTrack FROM FUNCTIONING PROPERLY. GREAT CARE SHOULD BE TAKEN WHEN EXECUTING SQL COMMANDS ON THE DATABASE. EXECUTING SQL COMMANDS ON THE DATABASE SHOULD ONLY BE CARRIED OUT BY PERSONS EXPERIENCED IN THE USE OF SQL COMMANDS AND WITH THE PROPER KNOWLEDGE OF THE MassTrack DATABASES. IT IS RECOMMENDED THAT A COMPLETE BACKUP OF THE DATABASES IS MADE PRIOR TO EXECUTING ANY SQL COMMANDS ON THE DATABASES.
