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.