Difference between revisions of "SYSBACKUPS"
From Lianjapedia
Yvonne.milne (Talk | contribs) (Created page with "==Purpose== Database snapshots ==See Also== BACKUP DATABASE, Lianja Cloud Admin Console, SYSTEM TABLES ==Description== System Tables are system...") |
Yvonne.milne (Talk | contribs) (→See Also) |
||
| Line 3: | Line 3: | ||
==See Also== | ==See Also== | ||
| − | [[ | + | [[COPY DATABASE]], [[Lianja Cloud Admin Console]], [[SQL System Tables|SYSTEM TABLES]] |
==Description== | ==Description== | ||
Latest revision as of 07:45, 27 May 2020
Contents
Purpose
Database snapshots
See Also
COPY DATABASE, Lianja Cloud Admin Console, SYSTEM TABLES
Description
System Tables are system defined read-only tables. You can query these tables using the SELECT statement.
| Column | Data Type | Width | Description |
|---|---|---|---|
| FILENAME | C | 80 | Filename |
| DATE | C | 10 | Creation date |
| TIME | C | 8 | Creation time |
| SIZE | N | 18 | File size |
Example
SELECT * FROM sysbackups
