Developing Database Structure
The Database Designer provides tools to help you create and maintain the structure of the database. The Table Designer devotes an entire window to the design of an individual table. The topics in this section explain how to manipulate various database objects to develop database structure.
In This Section
- Working with Databases
- Control changes to your database made in a database diagram.
- Working with Tables
- Add, remove, and manipulate tables in your database.
- Working with Columns
- Edit column properties directly in a database diagram or the Table Designer.
- Working with Keys
- Add, remove, and manipulate primary keys and foreign keys.
- Working with Relationships
- Create and modify associations between table rows.
- Working with Indexes
- Add, delete, and manage indexes for fast access to table rows or enforcing certain constraints.
- Working with Constraints
- Create and manage various types of constraints.
- Working with Triggers
- Create and manage triggers to help manage your data.
- Working with Stored Procedures and User-Defined Functions
- Create and modify stored procedures.
- Working with Scripts
- Preserve your work in SQL Scripts.
- 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 Development and Visual Database Tools
- Provides an overview of the tools included and how to manage large database projects.
- Database Queries and Visual Database Tools
- Explains concepts behind creating queries and views of your data in Visual Database Tools.
- 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.