SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Why auto complete not showing table names in non dbo schema?

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Why auto complete not showing table names in non dbo schema?
Author Message
THenrich



Joined: 17 Dec 2014
Posts: 20
Country: United States

Post Why auto complete not showing table names in non dbo schema? Reply with quote
Version 10 beta.

When I start typing a table name, I don't get any suggestions for tables if they are not in the dbo schema and I have to type the schema name first to get the suggestions. Which option controls this behavior?

Even sometimes for tables under dbo schema, it doesn't work consistently. I have a table called notes. When I type no, I get a list of keywords which start with no. No table names. I have refreshed the cache several times. If I type dbo.no then I get the suggestions. This is clearly an issue.
Thu Aug 23, 2018 2:31 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post Reply with quote
That should be caused by your account or security settings.

To test, open SQL Assistant Option dialog, navigate to
DB Options tab, then expand DB Queries section. Then find "Objects (MSSQL) + Typed Synonyms" query in the list
Copy its text to the editor.
Replace all occurrences of [$DB_NAME$] with database name in question.
Replace all occurrences of :SCHEMA_ID with the schema I'd of a non dbo schema.
Execute the query.

What you see in the result should match the object names you see in the popup. It's query driven. Try to figure out why for your login that doesn't work. In case the query returns expected results, then there is an issue with retrieving schema ids. In that case see the "Schemas (MSSQL)" query.
Thu Aug 23, 2018 4:52 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.