# Alter Script

**URL:** <https://forums.toadworld.com/t/alter-script/34266>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [October 9, 2015, 3:07am UTC](https://forums.toadworld.com/t/alter-script/34266 "2015-10-09T03:07:41Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mshannon](https://avatars.discourse-cdn.com/v4/letter/m/7feea3/32.png) [@mshannon](https://forums.toadworld.com/u/mshannon)\
**Post date:** [October 9, 2015, 3:07am UTC](https://forums.toadworld.com/t/alter-script/34266/1 "2015-10-09T03:07:41Z")

</div>

Upon modifying a table, we often display and copy the SQL to include in internal scripts.

We sometimes forget to remove the domain from the table causing problems with delivery to other systems ( which have different domains ).

Is there a setting whereas the domain name is not included in the SQL ?

---

<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:** [October 9, 2015, 5:30am UTC](https://forums.toadworld.com/t/alter-script/34266/2 "2015-10-09T05:30:00Z")

</div>

I guess by “domain”, you mean Schema?

If so, in the current beta, and in 12.8 to be released in the next month, you can rt-click on the Show SQL button to get a “Show SQL without Schema” option.

---

<div class="post-metadata">

**Author:** ![mshannon](https://avatars.discourse-cdn.com/v4/letter/m/7feea3/32.png) [@mshannon](https://forums.toadworld.com/u/mshannon)\
**Post date:** [October 9, 2015, 5:33am UTC](https://forums.toadworld.com/t/alter-script/34266/3 "2015-10-09T05:33:10Z")

</div>

My bad. I meant schema.

That is great news, thanks !

_ **Mike Shannon** _

**From:** John Dorlon [[mailto:bounce-jdorlon@toadworld.com](mailto:bounce-jdorlon@toadworld.com)]

**Sent:** Friday, October 09, 2015 8:31 AM

**To:** [toadoracle@toadworld.com](mailto:toadoracle@toadworld.com)

**Subject:** RE: [Toad for Oracle - Discussion Forum] Alter Script

**[RE: Alter Script](http://www.toadworld.com/products/toad-for-oracle/f/10/p/25593/56632#56632)**

Reply by John Dorlon

I guess by “domain”, you mean Schema?

If so, in the current beta, and in 12.8 to be released in the next month, you can rt-click on the Show SQL button to get a “Show SQL without Schema” option.

To reply, please reply-all to this email.

[Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/f/10/t/25593?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - General](http://www.toadworld.com/products/toad-for-oracle/f/10?subscribe=false) notifications altogether.

Toad for Oracle - Discussion Forum

[Flag](http://www.toadworld.com/products/toad-for-oracle/f/10/p/25593/56632?AbuseContentId=2ed21db6-4b03-45c0-afa7-7e64fc043c7f&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
this post as spam/abuse.
