The following Adaptive Server Enterprise system procedures are provided in Sybase 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. |
sp_helptext |
Displays the text of a system procedure or view |
sp_password |
Adds or changes a password for a user ID |
