This documentation is archived and is not being maintained.

Work You Can Do With the Visual Database Tools

The Query and View Designer lets you build SQL statements that retrieve data or modify the contents of tables. The Database Designer graphically represents tables and their relationships and lets you create and modify database objects. The Table Designer lets you focus on the design of a single table. All this can be done while you are connected to the underlying database. Thus, you can design, query, and populate your databases from within the design environment that you use to build your application.

Note   Visual Database Tools work only with Microsoft SQL Server and Oracle databases. The available features depend on your version of Visual Studio. For more information, see Visual Database Tools Editions.

With Microsoft Visual Database Tools, you can:

  • Connect to and explore any ODBC-compliant database.
  • Create and modify SQL Server databases using database diagrams.
  • Design, execute, and save complex queries.
  • Add, update, and delete data stored in database tables.
  • Design objects, such as tables, triggers, and stored procedures, in Microsoft SQL Server and Oracle databases.
  • Drag database objects onto a design surface, such as an HTML template form, and then drop to bind controls to those objects.

See Also

Database Development and Visual Database Tools | Database Queries and Visual Database Tools