Campbell Scientific LNDB LoggerNet Database Software - Manual (Page 45)

Appendix B. SQL Commands
LNDB requires you to have rights to the following commands based on the
database type:
SQL Server Compact
No security available.
SQL Server
Command Usage
Alter Used to add columns to existing data tables
Create Table Creates meta and data tables
Drop
Delete tables (only initiated by user in LNDB Manager).
Also used when creating a temporary meta table during an
archive.
Delete
Deletes meta table records. (Never deletes data table
records.)
Insert Meta table and data table inserts.
sp_rename Stored procedure used to rename a table during an archive.
Select Meta table and data table data requests.
Update Used to update meta table records during an archive.
References Used when creating meta tables.
MySQL
Command Usage
Alter
Used to add Columns to existing data tables. Also used to
rename data tables.
Create Table Creates meta and data tables
Drop
Delete tables (only initiated by user in LNDB Manager).
Also used when creating a temporary meta table during an
archive.
Delete
Deletes meta table records. (Never deletes data table
records.)
Insert Meta Table and data table inserts.
Select Meta Table and data table data requests.
Update Used to update meta table records during an archive.
References Used when creating meta tables.
B-1