Querying the System Tables

Query system tables in the same manner as any other tables.

For example, the following statement returns the names of all triggers in the database: 
select name 
from sysobjects 
where type = "TR"

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

These system procedures 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_showcontrolinfo

  • sp_helpindex

  • sp_showexeclass

  • sp_helpjava

  • sp_showplan

  • sp_helpjoins

  • sp_spaceused

  • sp_helpkey

  • sp_who

  • sp_helplanguage

  • sp_help_resource_limit

  • sp_helplog

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

Parent topic: System Tables