Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Any one please help me on this one also..I have got many schemas under one database. And in that database I have some SQL Scripts to be executed. My issue is that I should be able to execute those sql scripts in only selected schemas.

That is::Suppose I have got totally 10 schemas(A to J). And I want to execute a script in all schemas except B,G,H (PROMPT THE USER FOR EXCEPTED SCHEMAS).How can I do this??

Thanks in advance..

share|improve this question
Can provide an example script that you might want executed? –  Shawn Melton Jun 24 '13 at 12:31
It is a bit confusing what exactly you're looking to do. What do you mean, "execute a script in all schemas"? You mean create an object or something in the schemas?? –  Thomas Stringer Jun 24 '13 at 12:45
the simplest way to "PROMPT THE USER FOR EXCEPTED SCHEMAS" is to use a simple gui - OR use READ-HOST –  Jimbo Aug 8 '13 at 19:18

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.