Visual Database Tools
Working with Databases
The Database Designer provides tools to help you change your database. You can control when and how changes to a database made in a database diagram are saved. You control these changes by noting which objects have changed and which remain unchanged in the database diagram, by saving changes only to selected tables, and by discarding unwanted changes. You can also use SQL
| To | See |
|---|---|
| Save changes made on a database diagram | Saving an Entire Database Diagram |
| Save changes to a selected table on a diagram | Saving Selected Tables on a Diagram |
| Save your work in table designer | Saving Your Work in Table Designer |
| Return to a previous version of a database diagram without saving changes | Discarding Modifications |
| Ensure that database objects have a unique name | Uniquely Naming Database Objects |