Tables in Each Adaptive Server Enterprise Database

Not all Adaptive Server Enterprise system tables are implemented in the Sybase IQ system catalog.

Tables in each ASE database

Table name

Description

Data?

Supported by IQ?

sysalternates

One row for each user mapped to a database user

No

No

syscolumns

One row for each column in a table or view, and for each parameter in a procedure. In Sybase IQ, use the owner name dbo when querying, i.e. dbo.syscolumns.

Yes

Yes

syscomments

One or more rows for each view, rule, default, and procedure, giving SQL definition statement.

Yes

Yes

sysconstraints

One row for each referential and check constraint associated with a table or column.

No

No

sysdepends

One row for each procedure, view, or table that is referenced by a procedure, view.

No

No

sysindexes

One row for each clustered or nonclustered index, and one row for each table with no indexes, and an additional row for each table containing text or image data. In Sybase IQ, use the owner name dbo when querying, i.e. dbo.sysindexes.

Yes

Yes

sysiqobjects

One row for each system table, user table, view, procedure, trigger, event, join index, constraint, domain (sysdomain), domain (sysusertype), column, and index.

Yes

Yes

sysiqvindex

One row for each non-fp iq index.

Yes

Yes

syskeys

One row for each primary, foreign, or common key; set by user (not maintained by Adaptive Server Enterprise).

No

No

syslogs

Transaction log.

No

No

sysobjects

One row for each table, view, procedure, rule, default, log, and (in tempdb only) temporary object.

Contains compatible data only

Yes

sysprocedures

One row for each view, rule, default, and procedure, giving internal definition.

No

No

sysprotects

User permissions information.

No

No

sysreferences

One row for each referential integrity constraint declared on a table or column.

No

No

sysroles

Maps server-wide roles to local database groups.

No

No

syssegments

One row for each segment (named collection of disk pieces).

No

No

systhresholds

One row for each threshold defined for the database.

No

No

systypes

One row for each system-supplied and user-defined data type.

Yes

Yes

sysusers

One row for each user allowed in the database.

Yes

Yes

Related reference
SYSCOLUMNS ASE Compatibility View
SYSCOMMENTS ASE Compatibility View
SYSINDEXES ASE Compatibility View
SYSIQOBJECTS ASE Compatibility View
SYSIQVINDEX ASE Compatibility View
SYSOBJECTS ASE Compatibility View
SYSTYPES ASE Compatibility View
SYSUSERS ASE Compatibility View