SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Object popup does not get non dbo schemas?

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Object popup does not get non dbo schemas?
Author Message
Mindflux



Joined: 25 May 2013
Posts: 804
Country: United States

Post Object popup does not get non dbo schemas? Reply with quote
I've seen gemisigo post about this before but didn't see a resolution.

If I have a non dbo schema, to select objects from that I have to drill down into the schema and then table/view, it doesn't come to the forefront/top of the popup like the 'dbo' objects do.

I see the 'Context' SQL Queries is likely the cause of this? Is this intentional? If so how can I adjust it to see more?
Mon Apr 26, 2021 7:43 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
The working is like, if it's in your current schema, you don't need to specify schema name in the object reference, else you need to start with the schema. The current schema is retrieved by the Context query.

You can set the default schema using ALTER USER statement. Unfortunately, that means that you change it permanently, so if you need to switch between schemas, you would need to set it every time
Mon Apr 26, 2021 8:24 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.