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
Re-optimizing 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_dropkey |
sp_helptext |
sp_addtype |
sp_droptype |
sp_hidetext |
sp_bindcache |
sp_estspace |
sp_poolconfig |
sp_bindefault |
sp_foreignkey |
sp_primarykey |
sp_bindrule |
sp_freedll |
sp_procxmode |
sp_cacheconfig |
sp_help |
sp_recompile |
sp_cachestrategy |
sp_helpartition |
sp_rename |
sp_chgattribute |
sp_helpcache |
sp_spaceused |
sp_checksource |
sp_helpconstraint |
sp_unbindcache |
sp_commonkey |
sp_helpextendedproc |
sp_unbindcache_all |
sp_cursorinfo |
sp_helpindex |
sp_unbindefault |
sp_depends |
sp_helpjoins |
sp_unbindrule |
sp_dropextendedproc |
sp_helpkey |
