You can copy procedures between databases or within the same database by using Sybase Central. If you copy a procedure within the same database, you must rename the procedure or choose a different owner for the copied procedure.
To copy a procedure and assign yourself as the owner, you must have the CREATE PROCEDURE system privilege in the database you are copying the procedure to. To copy a procedure and assign a different user as the owner, you must have the CREATE ANY PROCEDURE or CREATE ANY OBJECT system privilege in the database you are copying the procedure to.
In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database that contains the procedure you want to copy.
Connect to the database that you want to copy the procedure to.
Select the procedure you want to copy in the left pane of the first database, and drag it to Procedures & Functions of the second database.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|