Sybase Adaptive Server Anywhere - Page 1096

Views for Transact-SQL Compatibility
1078
Table name Description Data?
sysindexes One row for each clustered or nonclustered
index, one row for each table with no indexes,
and an additional row for each table containing
text or image data.
Yes
syskeys One row for each primary, foreign, or common
key; set by the user (not maintained by Adaptive
Server Enterprise)
No
syslogs Transaction log No
sysobjects One row for each table, view, procedure, rule,
trigger default, log, or (in tempdb only)
temporary object
Contains
compatible
data only
sysprocedures One row for each view, rule, default, trigger, or
procedure, giving the internal definition
No
sysprotects User permissions information No
sysreferences One row for each referential integrity constraint
declared on a table or column
No
sysroles Maps server-wide roles to local database groups No
syssegments One row for each segment (named collection of
disk pieces)
No
systhresholds One row for each threshold defined for the
database
No
systypes One row for each system-supplied or user-
defined data type
Yes
sysusermessages One row for each user-defined message Yes (this is
an Adaptive
Server
Anywhere
system table)
sysusers One row for each user allowed in the database Yes
Table name Description Data?
syscharsets One row for each character set or sort order No
sysconfigures One row for each user-settable configuration
parameter
No
syscurconfigs Information about configuration parameters
currently being used by the server
No
sysdatabases One row for each database on the server No
Tables existing in
the Adaptive
Server Enterprise
master database