Not all Adaptive Server Enterprise master database tables are implemented in the Sybase IQ system catalog.
Table name |
Description |
Data? |
Supported by IQ? |
|---|---|---|---|
syscharsets |
One row for each character set or sort order |
No |
No |
sysconfigures |
One row for each configuration parameter that can be set by a user |
No |
No |
syscurconfigs |
Information about configuration parameters currently being used by the server |
No |
No |
sysdatabases |
One row for each database on the server |
No |
No |
sysdevices |
One row for each tape dump device, disk dump device, disk for databases, and disk partition for databases |
No |
No |
sysengines |
One row for each server currently online |
No |
No |
syslanguages |
One row for each language (except U.S. English) known to the server |
No |
No |
syslocks |
Information about active locks |
No |
No |
sysloginroles |
One row for each server login that possesses a system-defined role |
No |
No |
syslogins |
One row for each valid user account |
Yes |
Yes |
sysmessages |
One row for each system error or warning |
No |
No |
sysprocesses |
Information about server processes |
No |
No |
sysremotelogins |
One row for each remote user |
No |
No |
syssrvroles |
One row for each server-wide role |
No |
No |
sysservers |
One row for each remote server |
No |
No |
sysusages |
One row for each disk piece allocated to a database |
No |
No |