Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Reference » System procedures » Adaptive Server Enterprise system and catalog procedures


Adaptive Server Enterprise system procedures

SQL Anywhere includes some Adaptive Server Enterprise system procedures. While these procedures perform the same functions as they do in Adaptive Server Enterprise, they are not identical. If you have preexisting scripts that use these procedures, you may want to review the procedure code. To see the text of a stored procedure, execute the following command.

sp_helptext 'dbo.procedure_name'

The implemented system procedures are described in the following table.

System procedure name / parameters Description
sp_addgroup @grpname Adds a group to a database
sp_addlogin @login_name , @passwd [, @defaultdb [, @deflanguage [, @fullname ] ] ] Adds a new login ID to a database
sp_addmessage @message_num , @message_text [, @language ] Adds a user-defined message to ISYSUSERMESSAGE, for use by stored procedure PRINT and RAISERROR calls
sp_addtype @typename , @phystype [, @ident_null ] Creates a user-defined data type
sp_adduser @login_name [, @name_in_db [, @grpname ] ] Adds a new user ID to a database
sp_changegroup @grpname , @name_in_db Changes a user group or adds a user to a group
sp_dropgroup @grpname Drops a group from a database
sp_droplogin @login_name Drops a login ID from a database
sp_dropmessage @message_number [, @language ] Drops a user-defined message
sp_droptype @typename Drops a user-defined data type
sp_dropuser @name_in_db Drops a user ID from a database
sp_getmessage @message_num , @msg_var [, @language ] Retrieves a stored message string from ISYSUSERMESSAGE, for PRINT and RAISERROR statements.
sp_helptext [ @objname ] Displays the text of a system procedure, trigger, or view
sp_password @caller_pswd , @new_pswd [, @login_name ] Adds or changes a password for a user ID