Alter Script

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 ?

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.

My bad. I meant schema.

That is great news, thanks !

Mike Shannon

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

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

To: toadoracle@toadworld.com

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

RE: Alter Script

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 on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.