 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
THenrich
Joined: 17 Dec 2014 Posts: 20 Country: United States |
|
Why auto complete not showing table names in non dbo schema? |
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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 |
|
 |
|
|
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
|
|
|