System Tables

Adaptive Server 15.7 contains new and changed system tables.

Changed system tables
System table Column added Description
sysattributes
  • object_cinfo2
  • object_datetime
  • Provides a character description for the object
  • Provides the date and time for the object
  • sysattributes adds the SP object_type, which stores options related to RSA Key pair regeneration and LR object_type, which stores options related to login profiles
sysdatabases   Adds status bits to the status4 column to indicate database-wide compression settings
sysoptions number

Lists the switch ID as an integer

sysobjects lobcomp_lvl
  • Adds status bits to the status3 column to indicate database-wide compression settings
  • lobcomp_lvl – compression level of the columns defined for large objects.
syscolumns inrowlen
  • Adds status bits to the status2 column to indicate if a column is explicitly defined as compressed
  • inrowlen – a nullable column that stores the user-specified, or derived in-row length for LOB columns created as in-row
  • lobcomp_lvl – compression level of the columns defined for large objects.
syslogins
crsuid
Server user ID of the creator of login or login profile
syslogins lpid Login profile ID
syssrvroles
  • lockdate
  • lockreason
  • locksuid
  • Date and time a role was locked
  • Reason a role was locked
  • ID of the user who locked the role
sysservers srvprincipal Specifies the remote server Kerberos principal name
syscomments
  • syb_syscommkey_dddddd
 

Adaptive Server version 15.7 adds these system tables, which are views of the master database and provide information about the configuration of data caches and pools.

System table Description
syscacheinfo

Provides information about data caches.

syspoolinfo

Provides information about cache pools.

syscachepoolinfo

Provides a row for each data cache pool that includes configuration information for the data cache. This view is a join between the syscacheinfo and syspoolinfo views.

See the Reference Manual: Tables