Export (0) Print
Expand All

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.

Related Sections

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
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