You can remove a trigger by dropping it or by dropping the trigger table with which it is associated.
The drop trigger syntax is:
drop trigger [owner.]trigger_name [, [owner.]trigger_name]...
When you drop a table, Adaptive Server drops any triggers associated with it. drop trigger permission defaults to the trigger table owner and is not transferable.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
