Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 30 / 536

Stored procedures
10
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.