microsoft / microsoft/vscode-mssql

[Feature Request]: Add setting to show / hide / postfix the schema of items in Explorer window

Open
#21,676 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

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

Description

### Feature Description

Please add a setting to show / hide / postfix the schema of items in the Explorer window.

Instead of
> ∨ Tables
> ❯ 𝄜 dbo.Atable
> ❯ 𝄜 dbo.Btable
> ❯ 𝄜 dbo.Ctable

show:
> ∨ Tables
> ❯ 𝄜 Atable
> ❯ 𝄜 Btable
> ❯ 𝄜 Ctable

or show:
> ∨ Tables
> ❯ 𝄜 Atable (dbo)
> ❯ 𝄜 Btable (dbo)
> ❯ 𝄜 Ctable (dbo)

### Problem and Motivation

In the explorer window I want to type the beginning of a table or view name to navigate to it.
Right now I must type "dbo.BTab…" to do this, always starting with the schema and a dot.
Having these options made searching by typing much easier.

### Related Area

- [ ] Connection dialog (SQL Server | Azure browse/Fabric browse)
- [ ] Query editor
- [ ] Query results panel
- [x] Object Explorer
- [ ] GitHub Copilot integration
- [ ] Preview/Edit data
- [ ] Table Designer
- [ ] Schema Designer
- [ ] Schema Compare
- [ ] Local SQL Server Container provisioning
- [ ] SQL database in Fabric provisioning
- [ ] DACPAC/BACPAC export/import
- [ ] SQL Database projects
- [ ] Query Plan Visualizer
- [ ] Other (please describe below)

### If you selected "Other", please describe the area

_No response_

### Confirmation

- [x] I have searched existing feature requests and couldn't find a match
- [ ] I want to help implement this feature

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.

Research direction

Start by tracing the Object Explorer entry point and how its item labels and extension settings are defined. Determine where schema-qualified names are rendered and how Explorer search uses them. Done means a setting supports showing, hiding, or postfixing schemas for tables and views, with typing navigation working for each option.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql, typescript
Domain
database
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.