These system procedures are used for:
Binding and unbinding rules and defaults
Adding, dropping, and reporting on primary keys, foreign keys, and common keys
Adding, dropping, and reporting on user-defined datatypes
Renaming database objects and user-defined datatypes
Reoptimizing stored procedures and triggers
Binding and unbinding objects to data caches
Reporting on database objects, user-defined datatypes, dependencies among database objects, databases, indexes, and space used by tables and indexes
Getting help on command syntax
The procedures in this category are
sp_addextendedproc
sp_addtype
sp_bindcache
sp_bindefault
sp_bindrule
sp_cacheconfig
sp_cachestrategy
sp_chgattribute
sp_checksource
sp_commonkey
sp_cursorinfo
sp_depends
sp_dropextendedproc
sp_dropkey
sp_droptype
sp_estspace
sp_foreignkey
sp_freedll
sp_help
sp_helpartition
sp_helpcache
sp_helpcomputedcolumn
sp_helpconstraint
sp_helpextendedproc
sp_helpindex
sp_helpjoins
sp_helpkey
sp_helptext
sp_hidetext
sp_poolconfig
sp_primarykey
sp_procxmode
sp_recompile
sp_rename
sp_spaceused
sp_unbindcache
sp_unbindcache_all
sp_unbindefault
sp_unbindrule
sp_version
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
