Table 9-44 describes the Adaptive Server Enterprise system procedures provided in Sybase IQ.
System procedure |
Description |
|---|---|
sp_addgroup group-name |
Adds a group to a database |
sp_addlogin userid, password[, defdb [, deflanguage [, fullname]]] |
Adds a new user account to a database |
sp_addmessage message-num, message_text [, language] |
Adds user-defined messages to SYSUSERMESSAGES for use by stored procedure PRINT and RAISERROR calls |
sp_addtype typename, data-type, [, "identity" | nulltype] |
Creates a user-defined data type. Note that Sybase IQ does not support IDENTITY columns. |
sp_adduser login_name [, name_in_db [, grpname]] |
Adds a new user to a database |
sp_changegroup new-group-name, userid |
Changes a user's group or adds a user to a group |
sp_dboption [dbname, optname, {true | false}] |
Displays or changes database options |
sp_dropgroup group-name |
Drops a group from a database |
sp_droplogin userid |
Drops a user from a database |
sp_dropmessage message-number [, language] |
Drops user-defined messages |
sp_droptype typename |
Drops a user-defined data type |
sp_dropuser userid |
Drops a user from a database |
sp_getmessage message-num, @msg-var output [, language] |
Retrieves stored message strings from SYSMESSAGES and SYSUSERMESSAGES for PRINT and RAISERROR statements. |
sp_helptext 'owner.object-name' |
Displays the text of a system procedure or view |
sp_password caller_passwd, new_passwd [, userid] |
Adds or changes a password for a user ID |
Procedures like sp_dropuser provide
minimal compatibility with Adaptive Server Enterprise stored procedures.
If you are accustomed to Adaptive Server Enterprise (or Sybase IQ 11.x)
stored procedures, you should compare their text with Sybase IQ 12
procedures before using the procedure in dbisql.
To compare, use the command
sp_helptext 'owner.procedure_name'
For system stored procedures delivered by Sybase, the owner is always dbo. To see the text of a stored procedure of the same name owned by a different user, you must specify that user, for example:
sp_helptext 'myname.myprocedure'
