I'm viewing a Trigger in the Schema Browser and I notice that the source script is concatenating the ON statement and Trigger Name in the Source tab. I have the "Parse Triggers for Schema Name" checked on. (In Script Options | Triggers Tab).
For example:
CREATE OR REPLACE TRIGGER GEORGE.HIP_COMPANY
BEFORE INSERT OR UPDATE
ONHIP_COMPANY
If I were to un-check the "Parse Triggers..." option, then it displays correctly:
CREATE OR REPLACE TRIGGER GEORGE.HIP_COMPANY
BEFORE INSERT OR UPDATE
ON HIP_COMPANY
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center