Return
-
Title
How to remove the schema name of triggers during Scripting? -
Description
How to remove the schema name of triggers when using Toad to generate script or extract DDL?
-
Resolution
1. Create the DDL from Database | Export | Generate Schema Script.
2. Go to "Script Options" tab and uncheck "Include schema name prefix for objects".
3. Ensure to uncheck "Script Options" | "Other Objects" | "Triggers" - "Never Parse Triggers for Schema Names"
-
Additional Information
The options Generate Export DDL options do not apply to Generate Schema Script. Generate Schema Script has its own set of options.