 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
Mindflux
Joined: 25 May 2013 Posts: 846 Country: United States |
|
Object popup does not get non dbo schemas? |
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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 |
|
 |
|
|
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
|
|
|