Usage: {code:SQL}ALTER TRIGGER ON name INSTEAD OF INSERT|UPDATE|DELETE \(AS FOR EACH ROW block) | \(ENABLED|DISABLED){code} |
Syntax Rules: |
... |
Usage:
ALTER TRIGGER ON name INSTEAD OF INSERT|UPDATE|DELETE (AS FOR EACH ROW block) | (ENABLED|DISABLED)
Syntax Rules:
Note If the default inherent update is chosen in Teiid Designer, any SQL associated with update (shown in a greyed out text box) is not part of the VDB and cannot be enabled with an alter trigger statement. |