# Suppress schema name showing in procedure/package/function source tab

**URL:** <https://forums.toadworld.com/t/suppress-schema-name-showing-in-procedure-package-function-source-tab/10921>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [December 12, 2011, 10:41am UTC](https://forums.toadworld.com/t/suppress-schema-name-showing-in-procedure-package-function-source-tab/10921 "2011-12-12T10:41:43Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Boneist](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/boneist/32/145_2.png) [@Boneist](https://forums.toadworld.com/u/Boneist)\
**Post date:** [December 12, 2011, 10:41am UTC](https://forums.toadworld.com/t/suppress-schema-name-showing-in-procedure-package-function-source-tab/10921/1 "2011-12-12T10:41:43Z")

</div>

This is probably a dumb question and there’s something really obvious that I’m missing, but I’d like to know how I can switch off the schema name from showing in the package/proc/function source tabs in v11, eg:

CREATE OR REPLACE FUNCTION SCHEMA\_NAME.function\_name…

I want that to display as:

CREATE OR REPLACE FUNCTION function\_name…

For the life of me, I cannot work out how to stop it from being appended - can’t see anything in the View \> Options (I’ve searched!) or any option on the rhs of the schema browser. I’m sure there’s a way to do it, because I’m pretty sure I had it set up this way in v10.6, but I just can’t find it!

Help?!

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [December 12, 2011, 10:41am UTC](https://forums.toadworld.com/t/suppress-schema-name-showing-in-procedure-package-function-source-tab/10921/2 "2011-12-12T10:41:43Z")

</div>

It follows the editor settings.

Options -\> Editor -\> open/save -\> owner name

---

<div class="post-metadata">

**Author:** ![Boneist](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/boneist/32/145_2.png) [@Boneist](https://forums.toadworld.com/u/Boneist)\
**Post date:** [December 12, 2011, 11:23am UTC](https://forums.toadworld.com/t/suppress-schema-name-showing-in-procedure-package-function-source-tab/10921/3 "2011-12-12T11:23:58Z")

</div>

Aha, thanks!

Unfortunately, changing that option to not include the schema name made Toad freeze \*{☹ (I’m running the latest beta, if that helps; 11.1.0.13)

1 restart later and it looks fine. Hurrah! \o/

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [December 12, 2011, 11:24am UTC](https://forums.toadworld.com/t/suppress-schema-name-showing-in-procedure-package-function-source-tab/10921/4 "2011-12-12T11:24:06Z")

</div>

I just tried changing that setting here and didn’t get a freeze. If you  
can reproduce it, please let me know exactly what the steps are to do that.  
Thanks.

-John

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [December 12, 2011, 11:26am UTC](https://forums.toadworld.com/t/suppress-schema-name-showing-in-procedure-package-function-source-tab/10921/5 "2011-12-12T11:26:18Z")

</div>

I have TOAD 11

I tried it didn’t freeze
