Adaptive Server Enterprise system procedures

Table 10-61 describes the Adaptive Server Enterprise system procedures provided in Sybase IQ.

Table 10-61: ASE 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. Sybase IQ does not support IDENTITY columns.

sp_adduser userid [, 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

NoteProcedures 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, 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'