SqlDbx
You are not logged in.
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
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
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
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