How to remove the schema name of triggers when using Toad to generate script or extract DDL?
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"
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy