microsoft / microsoft/vscode-mssql
[Bug]: IntelliSense after SELECT * FROM only suggests dbo tables
@aasimkhan30 is already working on this.
Since Sep 2, 2026.
- 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
- Connect to a database that has user tables in multiple schemas, for example:
dbo.Customerssales.Ordersinventory.Products
- Open a SQL query editor.
- Type
SELECT * FROMand trigger IntelliSense. - Review the suggested table names.
Example:
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
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.