consists only of a single tool called SQL Server Object Explorer. You
can install SSDT Power Tools by searching in Visual Studio’s Extension
Manager for “SSDT Power Tools.” Note that if you’ve used a tool called
Schema View in the previous incarnations of SSDT, you’ll be familiar
with SQL Server Object Explorer, because it provides pretty much the
same set of features.
SQL Server Object Explorer is complementary to Visual Studio’s
Solution Explorer pane because it provides a logical view of the objects
that are defined within the project in Solution Explorer. What does that
mean exactly? Perhaps a better way of describing it is that Solution
Explorer shows a collection of files (like Windows Explorer) whereas
SQL Server Object Explorer shows a collection of database objects (like
SSMS). A screenshot might explain this better: In Figure 5, we see the
DDL script for a table, [dbo].[Product], open and in full view. That
same script, Product.sql, is in Solution Explorer; and over on the left
Figure 5
Script in SQL Server
Object Explorer