System Procedures

System procedures are shortcuts for retrieving information from the system tables, and mechanisms for performing database administration and other tasks that involve updating system tables.

Usually, system tables can be updated only through stored procedures. A system administrator can allow direct updates of system tables by changing a configuration variable and issuing the reconfigure with override command. See, Managing User Permissions, in the Security Administration Guide.

System procedures are created by the installmaster script in the sybsystemprocs database during SAP ASE installation. The name of the system procedure usually indicates its purpose. For example sp_addalias adds an alias.