Filter
Top Products
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.