System Tables

New and changed system tables in Adaptive Server 15.5

New system tables
System table Description
spt_TableTransfer Stores the results from table transfers.

Changed system tables
System table Change description
sysdevices Lists the in-memory storage cache under the name and phyname columns. In-memory devices do not include a full path to the disk device, instead, they store the name of the cache on which the in-memory device has been created.
sysdatabases Adds the durability column, which indicates the durability level of the database. The durability column has the int datatype. Its values are:
  • 1 – full
  • 5– at_shutdown
  • 6 – no_recovery

See the Reference Manual: Tables.