CODEWITHSUNDEEP
toaduser-preferences
Eric12345
Eric12345

Reputation: 257

Toad schema name in objects

In the Schema Browser, Toad automatically includes the schema name in the name of database objects. For example, when I click on a procedure to see it's source, it goes:

CREATE OR REPLACE PROCEDURE MY_USER.MY_PROCEDURE

Is there a way to disable this? Such that it shows

CREATE OR REPLACE PROCEDURE MY_PROCEDURE

This would make copying code and running it in other schema's a lot easier!

Upvotes: 0

Views: 1626

Answers (1)

Michael S.
Michael S.

Reputation: 1791

This is not intuitive at all, but the Schema Browser is using the Editor option to include schema names. See the Editor|Open/Save page in Options. Set the "Owner name" value accordingly in the "Object loading" group box.

Always include - always includes schema name

Never include - never includes schema name

Include on loads from other schemas - includes name when the object is not owned by the logged on schema

Upvotes: 1

Related Questions