SqlDbx Forum

SqlDbx

You are not logged in.

#1 2010-03-22 04:28:58

Timo
Member

How to change the Current schema from the editor?

How do I change the Current schema from the editor?

When I execute the following statement: USE peno
nothing happens. While I expected the current schema to be changed to the db peno

Is this on purpose or a bug?

Greets

Timo

Offline

#2 2010-03-22 21:21:35

sqldbxhelp
Administrator

Re: How to change the Current schema from the editor?

I am not sure what do you expect when you run USE peno?
Current database will change to peno.
Do you expect Obect list to switch to a new database too?

Offline

#3 2010-03-23 03:39:53

Timo
Member

Re: How to change the Current schema from the editor?

Yes thats what I expect.
Now I can only see that the query is executed succesfully.
But there is nothing that indicates that the db has changed to peno (name of the db I want to switch to).

Thus yes I expect the object to switch to the new db to.

But come to think of it.
If I want to run a batch that uses multiple USE statements I want the object list not to switch,
thus I need an option or something that allows me to turn autoswitching the object list off.

Offline

#4 2010-03-24 11:00:04

sqldbxhelp
Administrator

Re: How to change the Current schema from the editor?

The name of the current db always displayed on a bottom right.
Automatically switching object list to new database after USE statement
does not look like a good idea to us. I am not aware of any tool which does it.
Can be pretty confusing.

Offline

Board footer

Powered by FluxBB