Chapter 16 System Views
1079
Table name Description Data?
sysdevices One row for each tape dump device, disk
dump device, disk for databases, or disk
partition for databases
No
sysengines One row for each server currently online No
syslanguages One row for each language (except U.S.
English) known to the server
No
syslocks Information about active locks No
sysloginroles One row for each server login that possesses a
system-defined role
No
syslogins One row for each valid user account Yes
sysmessages One row for each system error or warning No
sysprocesses Information about server processes No
sysremotelogins One row for each remote user No
sysservers One row for each remote server No
syssrvroles One row for each server-wide role No
sysusages One row for each disk piece allocated to a
database
No
Table name Description Data?
sysaudits One row for each audit record No
sysauditoptions One row for each global audit option No
Tables existing in
the Adaptive
Server Enterprise
sybsecurity
database
To Next Page
Loading...