Edit a trigger to change the name, trigger events, and other properties.
Prerequisites Before you can edit a trigger, be sure the data server that contains the trigger is
running, and you created and established a connection to the data
server.
- Expand the table that contains the trigger.
- Under the
Triggers folder, find the trigger you want to
edit, right-click the
trigger, and choose
Edit.
The Trigger Editor page opens.
- Edit the trigger properties.
Editor
Tab |
Description |
General |
- Change the trigger name in the Name field.
- You can disable the trigger by clicking Disable trigger. This restricts the database from starting the trigger automatically.
- Select
For update,
For insert, or
For delete to indicate the condition under which the trigger is to be invoked when the associated table is modified.
|
Source |
Manually edit the SQL code for the trigger in the Source tab. To display line numbers for the SQL code, right-click in the left margin, and choose Show Line Numbers from the context menu. |
DDL |
Select this tab to view the DDL for the trigger. Content in
this tab is not modifiable. |
- When you are
finished editing the trigger, choose
from the main WorkSpace menu to save your
changes.
Send your feedback on this help topic to Sybase Technical Publications:
pubs@sybase.com
Your comments will be sent to the technical publications staff at Sybase, Inc.
For product-related issues or technical support, contact Sybase Technical Support
at 1-800-8SYBASE.