Campbell-scientific LNDB LoggerNet Database Software Instrukcja Użytkownika Pobierz pdf (Strona 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

1 2 ... 40 41 42 43 44 45 46 47 48

Brak uwag

Campbell-scientific LNDB LoggerNet Database Software Instrukcja Użytkownika Strona 45