command 'extension.addObjectExplorer' not found when using VS Code mssql extension

Question

VS Code team finally dropped the long-awaited SQL Object Explorer feature in its mssql extension the other day. However, when I click the SQL Server icon in the tool bar, I get an error message command 'extension.addObjectExplorer' not found

Uninstalling the mssql extension, and restarting/reinstalling it didn't help.

I thought this might be a package build issue, but I don't see any such issue reported on github or anywhere on the internet.

Did anyone experience this issue?

Answer 1

I was experiencing this issue. In my case this issue was resolved by uninstalling the SQL Server (mssql) extension, deleting the existing extension files, and reinstalling the extension. Check the output windows "Log (Extension Host)" view for the exact path on your system. On my system it was:

.vscode/extensions/ms-mssql.mssql-1.7.0

Updating to the latest version did not resolve the issue in my situation, and neither did simply uninstalling and re-installing the extension. I needed to delete the extension from disk as well.