Not all Adaptive Server Enterprise system tables are implemented in the Sybase IQ system catalog.
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 |