Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Database Development and Visual Database Tools

Database Development and Visual Database Tools

Visual Studio .NET 2003

As you design a database, you create database objects such as tables, columns, keys, indexes, relationships, constraints, and views. To help you create these objects, the Visual Database Tools provides three mechanisms: the Database Designer, the Table Designer, and the Query and View Designer. It is important to understand the interactions among the various tools and your database.

In This Section

Database Designer
Describes how this tool allows you to create tables, columns, keys, indexes, relationships, and constraints. Within the Database Designer, you interact with database objects through database diagrams, which graphically show the structure of the database. With the Database Designer you can create and modify objects that are visible on diagrams (tables, columns, relationships, and keys) and some objects that are not visible on diagrams (indexes and constraints).
Table Designer
Describes how this tool helps you to create an individual table. Although you can create tables with the Database Designer, the Table Designer is sometimes more convenient for this task, because it devotes a larger portion of the screen to the table and shows more detail about the table as you design it.
SQL Editor
Provides details on many useful SQL text editing features.
Database Objects
Provides links to topics describing the uses and advantages of various database objects you can use with the Visual Database Tools to design a database.
Interactions Among Database Diagrams and Table Design Windows
Explains how your database diagram and table design changes are saved in memory until you explicitly choose to save them to the database.
Interactions Among Database Diagrams, Table Design Windows, and the Database Catalog
Explains how database diagrams and table design windows get saved to the database.
Large Database Projects
Provides links to topics covering special challenges common to large database projects: multiple people designing a single database, making changes to a deployed database, and managing multiple versions of a single database.

Related Sections

Query and View Designer
Explains the panes of these tools that help you create queries and views.
Overview of Visual Database Tools
Provides links to topics describing what's new in Visual Database Tools and how the tools interact with your database.
Database Queries and Visual Database Tools
Explains concepts behind creating queries and views of your data in Visual Database Tools.
Developing Database Structure
Gives detailed steps for designing and maintaining database structure through tables, columns, keys, indexes, stored procedures, and more.
Designing Data Retrieval and Manipulation
Provides links to topics with details on how to design queries and views as well as how to modify data.
Reference
Provides links to general reference topics covering queries, operators, search conditions, specific DBMS requirements, user interface reference topics, and error message topics.
Show:
© 2015 Microsoft