System tables  Keys in system tables

Chapter 1: Overview of System Administration

Querying the system tables

You can query system tables in the same manner as 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_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.




Copyright © 2005. Sybase Inc. All rights reserved. Keys in system tables

View this book as PDF