Querying the system tables

You can query system tables just like any other tables. For example, the following statement returns the names of all the triggers in the database:

select name 
from sysobjects 
where type = "TR"

In addition, Adaptive Server supplies stored procedures (called system procedures), many of which provide shortcuts for querying the system tables.

Here are the system procedures that provide information from the system tables:

sp_commonkey	sp_helpremotelogin
sp_configure	sp_help_resource_limit
sp_countmedatada	sp_helprotect
sp_dboption	sp_helpsegment
sp_estspace	sp_helpserver
sp_help	sp_helpsort
sp_helpartition	sp_helptext
sp_helpcache	sp_helpthreshold
sp_helpconfig	sp_helpuser
sp_helpconstraint	sp_lock
sp_helpdb	sp_monitor
sp_helpdevice	sp_monitorconfig
sp_helpgroup	sp_procqmode
sp_helpindex	sp_showcontrolinfo
sp_helpjava	sp_showexeclass
sp_helpjoins	sp_showplan
sp_helpkey	sp_spaceused
sp_helplanguage	sp_who
sp_helplog	sp_help_resource_limit

For complete information about the system procedures, see the Reference Manual.