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 |
 |
Discuter à propos de cette page dans DocCommentXchange.
|
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0 |