Visual Database Tools

Visual Database Tools help you create and maintain databases and manage data-driven applications.

Note

Visual Database Tools work best with Microsoft SQL Server databases. For more information see Providers and Data Sources in Visual Database Tools. The available features depend on your version of Visual Studio. For more information, see Visual Database Tools Editions.

This version of Visual Database Tools does not support Microsoft SQL Server 7.0 and earlier.

In This Section

• Overview of Visual Database Tools
  Provides links to topics describing what is new in Visual Database Tools and how the tools interact with your database.

• Understanding Visual Database Tools
  Provides links to conceptual topics about the tools included and how to manage multiuser database projects.

• Working with Database Projects
  Provides links to procedural topics about using Visual Database Tools with a Database Project.

• Designing Database Diagrams
  Provides links to topics about using Database Diagram Designer.

• Designing Tables
  Provides links to topics with details on how to design tables.

• Designing Queries and Views
  Provides links to a range of procedural and conceptual topics about using Query and View Designer to return results and modify data.

• Working with Stored Procedures and User-Defined Functions
  Provides links to procedural topics about using stored procedures and user-defined functions with Visual Database Tools.

• Working with Constraints
  Provides links to procedural topics about using constraints, which are rules that the database server enforces for you.

• Working with Triggers
  Provides links to procedural topics about using triggers with Visual Database Tools.

• Working with Scripts
  Provides links to procedural topics about using Change and Create scripts with Visual Database Tools.

• Reference (Visual Database Tools)
  Provides links to topics that describe the properties of database objects and the Visual Databases Tools dialog boxes.