The Database Designer provides tools to help you make changes to your database. You can control when and how changes to a database made in a database diagram are saved by noting which objects have been changed and which remain unchanged in the database diagram, by saving changes only to selected tables, and by rolling back unwanted changes. You can also use SQL change scripts to track, rollback, and apply unsaved changes.
| To | See |
| Use database diagrams to control changes to the database | Controlling Database Changes Through Database Diagrams |
| Save changes to a selected table | Saving Selected Tables |
| Save a change script | Saving a Change Script |
| Return to a previous version of a database diagram without saving changes | Rolling Back Unsaved Database Changes |
| Ensure that database objects have a unique name | Uniquely Naming Database Objects |