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.
Note
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.
Solution Explorer
Use Solution Explorer to:
Add database references to a Database project.
Save Change scripts, Create scripts, and Queries to a Database project.
Server Explorer
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 Transact-SQL/SQLCLR routines.
Database Diagram Designer
Use Database Diagram Designer to:
Show all or part of the structure of a database.
View relationships between database tables.
Modify the structure of a database.
Table Designer
Use Table Designer to:
Create new tables.
Open tables for editing.
Edit column properties.
Create or modify relationships.
Set primary and unique keys.
Create or modify indexes, including XML and full-text indexes.
Create or modify constraints.
Create Change scripts.
Query and View Designer
Use Query and View Designer to:
Create views and queries, including Select, Update, Delete, Make Table, Insert Values, and Insert Results queries.
Return results for modification.
See Also
Reference
Concepts
Visual Database Tools Editions
Other Resources
What's New in Visual Database Tools
Understanding Visual Database Tools