IntelliSense: Choosing the reference database
Completion reads real object and column names from a real database — not a guess from the text infront of it.
Completion reads real object and column names from a real database — not a guess from the text in front of it.
Each script remembers which database its completion resolves against. Open the picker from the editor's status area:
| Choice | |
|---|---|
| Automatic | The first non-production database in the target group, following the group as it changes |
| A specific connection | Pinned, whatever the target group is |
| No IntelliSense target | Keywords, snippets and variables only |
A production database in the picker carries a badge. The picker's own note says the rest: it changes where IntelliSense reads, never where a run goes.