Database Development and Visual Database Tools
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.
- 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.
- Provides links to general reference topics covering queries, operators, search conditions, specific DBMS requirements, user interface reference topics, and error message topics.