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

LNDB
6.2.1 Deleting or Archiving Tables
All database tables except the meta tables (LNDBStationMeta,
LNDBTableMeta, and LNDBColumnMeta) can be removed by clicking the
Delete button or archived by clicking the Archive button. If a meta table is
selected, the Delete and Archive buttons are grayed out.
When you archive a table, you are asked for an archive name. The default
name is <basename>_arch<number>. Basename is the first part of the name
before the first "_arch". Number is the smallest number that makes the table
name unique. The maximum number of characters allowed for the table name
is 64 for MySQL and 128 for SQL Server and SQL Server Compact.
Upon completion of a Delete or Archive, any conflicts for the table are
removed and storage is restarted for the table (if enabled for storage).
When storage begins for a newly created table, data always
backfills and starts at the oldest available record. It does not start
at the last record from the deleted or archived table. Therefore, a
table may be recreated so quickly after deletion, that it may
appear as if the table was not actually deleted. NOTE
The format of timestamp columns is based on the precision of the first two
records shown. If the time has second data, it will be shown. If the time has
sub-second data, it will show 3 or 7 decimal places based on the precision.
6.3 Significant Events Tab
17