microsoft / microsoft/vscode-mssql

[Bug]: IntelliSense after SELECT * FROM only suggests dbo tables

Open
#21,883 0 comments 3 reactions 1 assignee View on GitHub

@aasimkhan30 is already working on this.

Since Sep 2, 2026.

Area - Language Service Bug User-filed
Dominant language
TypeScript
Stars
1.9k
Forks
610
Avg merge
2d 3h
Merged PRs (30d)
97

Description

Description

When typing a query such as SELECT * FROM , IntelliSense only suggests tables from the dbo schema and does not include tables from other schemas.

This makes schema-aware object discovery incomplete in the most common table completion path. If the connected database contains tables under schemas other than dbo, those tables should also appear in the completion list.

Steps to Reproduce
  1. Connect to a database that has user tables in multiple schemas, for example:
    • dbo.Customers
    • sales.Orders
    • inventory.Products
  2. Open a SQL query editor.
  3. Type SELECT * FROM and trigger IntelliSense.
  4. Review the suggested table names.

Example:

Image Image

I don't see SignArchive table which is in test schema

Expected Behavior

IntelliSense should suggest tables from all relevant schemas in the database, not just dbo.

Actual Behavior

IntelliSense only shows dbo tables and does not surface tables from non-dbo schemas.

Affected Area
  • Query editor
  • Language service / IntelliSense behavior
Environment Information
  • VS Code Version: [fill in]
  • MSSQL Extension Version: [fill in]
  • Operating System: Windows
  • Connection Type: SQL Server

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.