in the Schema Browser | Rebuild this Table feature. Is there a way to keep it from including the schema name of tables, views, etc. in the output.
I also try the below but it doesn't apply to the Rebuild Tables:
1) In the right side of the schema browser, select the script tab.
2) Click the "view/edit script options" button in the script tabs tool bar.
3) On the common tab, in the create and drop section, check the Schema Name option and hit OK.
,
Workaround:
As a workaround for this you can send the SQL to the Editor (button). Once in the editor, do a Find & replace, replacing the schema name with nothing.
Status:
There is no way not to include the schema name in rebuild table and it has always been like this.If you feel that this feature is useful and would like to add it, I encourage you to visit the IdeaPond when you have time to submit an Enhancement for this. Customer feedback is what has made Toad what it is today. In order to get your enhancement requests directly to the Toad development team, Quest has launched an exciting new portal, the Toad Idea Pond.
https://www.toadworld.com/products/toad-for-oracle/i
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center