Work You Can Do With the Visual Database Tools
The Visual Database Tools let you connect to a database and view and manipulate its structure and data. There are five tools in this tool set, each providing its own set of features. For information on which features are available in your edition of Visual Studio see Visual Database Tools Editions.
Visual Database Tools works best with Microsoft SQL Server databases. If you are not using a Microsoft SQL Server database some features may not be available.
This version of Visual Database Tools does not support Microsoft SQL Server 7.0 and earlier.
Use Server Explorer to:
Create, modify, delete, and refresh database connections.
Create a new Microsoft SQL Server database.
Create new database objects, such as diagrams, tables, views, triggers, stored procedures, and user-defined types.
View and access database objects.
Generate Create scripts for various database objects.
Execute/Debug TSQL/SQLCLR routines.