Alter a trigger by using Sybase Central to edit the code of the trigger or add a comment.
To add or edit a comment, you must have one of the following system privileges:
To edit the code, you must have the ALTER ANY OBJECT system privilege or the ALTER ANY TRIGGER system privilege and one of the following:
Context and remarks
In Sybase Central, you cannot rename an existing trigger directly. Instead, you must create a new trigger with the new name, copy the previous code to it, and then delete the old trigger.
In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
In the left pane, double-click Triggers.
Select a trigger.
Use one of the following methods to alter the trigger:
|Edit the code||
You can either right-click the trigger and click Edit in New Window, or you can edit the code in the SQL tab in the right pane.
You can open a separate window for each procedure and copy code between triggers.
|Add a comment||
To add or edit a trigger comment, right-click the trigger and click Properties.
If you use the Database Documentation Wizard to document your SQL Anywhere database, you have the option to include these comments in the output.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|