The schema name appears in the beginning of the object name for the create scripts. How can the schema name prefix be removed in the Schema Browser RHS panel and Export DDL?
For the Export DDL feature, you can achieve turning off the schema name prefix for all objects including procedures and packages by un-checking the "Schema Name" checkbox in:
Database Main Menu | Export | Export DDL | "Script Options" Tab | "Common" Tab | uncheck "Schema Name" checkbox.
After doing this, the above option will be remembered by Toad and will remain unchecked no matter what object is performed with Export DDL.
As far as removing the schema name prefix in the Right Hand Side (RHS) panel of the Schema Browser window, go to:
View Menu | Toad Options | Editor | Open / Save | under "Object Loading" - "Owner Name" section | check mark the box for "Never Include".
To remove the schema name prefix temporarily on one procedure or package only:
Right-click the procedure or package in the left hand side (LHS) of the Schema Browser | select Create Script | click on Script Options Tab | and uncheck the "Schema Name" box.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center