CODEWITHSUNDEEP
sql-servervisual-studio
John Little
John Little

Reputation: 12338

Visual Studio Community: how to view data or run SQL in the "SQL Server Object Explorer"

You can "explore" the schema etc. using the SQL Server Object Explorer in VS.

However, I can't find a way to view the data in a given table (at least the first page), or to run some arbitrary SQL.

Is this possible?

I also have the full blown Microsoft SQL Server Manager installed, but this can't "see" the databases created by Visual Studio in its built-in SQL Server Express instance. It can only connect to its own full blown SQL Server databases.

I have looked for a tool to view data in SQL Server Express, but have not found anything yet. There does not seem to be a version of Microsoft SQL Server Manager for SQL Server Express unfortunately.

Upvotes: 5

Views: 2748

Answers (1)

marc_s
marc_s

Reputation: 754268

You can do a "New Query" on any database node to run a query window:

enter image description here

And then you can do a "View Data" on any table, in SQL Server Object Explorer:

enter image description here

But you should also be able to load any "LocalDB" instance and view it from the full-fledged SQL Server Management Studio (at least since SSMS v17, where it's a separate, free download)....

Upvotes: 6

Related Questions