<< Click to Display Table of Contents >> Navigation: 5. Administration and Customization > 5.7 Database Administration > 5.7.3 Execute SQL Commands on Database |
Administration and Customization > Database Administration
From the SQL window, administrator users can execute SQL commands on the databases directly from ShipWeight. 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 ShipWeight 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 ShipWeight DATABASES. IT IS RECOMMENDED THAT A COMPLETE BACKUP OF THE DATABASES IS MADE PRIOR TO EXECUTING ANY SQL COMMANDS ON THE DATABASES.