April 23, 2024 at 4:56 am
Maybe I'm just doing something really simple and dumb.
I imported a bunch of tables from Access to SQL Server. Worked fine. I click on Tables and select Refresh, and even after doing that, the intellisense doesn't work.
If I create a query and start with something silly like
SELECT t.
FROM MyTable t
normally, I type the "t." part, I get a dropdown or whatever of column names, but now I don't. The other odd thing is that if I type
SELECT *
FROM dbo.
I'll get the dropdown showing all the tables in the schema. But the tables I just imported don't show up. (Selecting the table and then Refresh doesn't fix it).
Am I doing something incredibly stupid or is something not working right in SSMS? If I do exactly the same thing with tables that have not been imported from Abscess, intellisense works just fine.
That's super weird. Any idea what's going on?
Thanks,
Pieter
April 23, 2024 at 8:17 am
Did you refresh the Intellisense local cache? CTRL-SHIFT R
Never heard it called Abscess before!
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
April 23, 2024 at 5:00 pm
yeah, you know, the database version of a weeping sore.
No, I didn't. gotta try that. Okay, seems to be okay now. Thanks for the tip!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply