Sybase 12.4.2 manual Adaptive Server Enterprise system procedures, System procedure Description

Stored procedures

System procedures are built-in stored procedures used for getting reports from and updating system tables. Catalog stored procedures retrieve information from the system tables in tabular form.

Note While these procedures perform the same functions as they do in Adaptive Server Enterprise and pre-Version 12 Adaptive Server IQ, they are not identical. If you have preexisting scripts that use these procedures, you may want to examine the procedures. To see the text of a stored procedure, run

sp_helptext procedure_name

You may need to reset the width of your DBISQL output to see the full text, by clicking Command→Options and entering a new Limit Display Columns value.

Adaptive Server Enterprise system procedures

The following Adaptive Server Enterprise system procedures are provided in Adaptive Server IQ. These stored procedures perform important system management tasks.

System procedure	Description
sp_addgroup	Adds a group to a database
sp_addlogin	Adds a new user account to a database
sp_addmessage	Adds user-defined messages to
	SYSUSERMESSAGES for use by stored
	procedure PRINT and RAISERROR calls
sp_addtype	Creates a user-defined data type
sp_adduser	Adds a new user to a database
sp_changegroup	Changes a user’s group or adds a user to a
	group
sp_dboption	Displays or changes database options
sp_dropgroup	Drops a group from a database
sp_droplogin	Drops a user from a database
sp_dropmessage	Drops user-defined messages
sp_droptype	Drops a user-defined data type
sp_dropuser	Drops a user from a database
sp_getmessage	Retrieves stored message strings from
	SYSMESSAGES and
	SYSUSERMESSAGES for PRINT and
	RAISERROR statements.

10