This section describes how to work with Programmability objects in Database Explorer. The Programmability node contains database objects such as assemblies, database triggers, defaults, functions, procedures, rules, sequences, plan guides, and user-defined types.
The following table describes the shortcut menu options available for the Programmability node in Database Explorer.
| Name | Description |
|---|---|
| Source Control > Source Control Manager | Opens Source Control Manager, where you can track and manage changes to database schema and static data. When Source Control Manager is already open, this option refreshes it. |
| Source Control > Commit | Opens Source Control Manager with all local changes (if any) selected and ready to commit. When Source Control Manager is already open, this option refreshes it and selects all local database changes. |
| Source Control > Get Latest | Opens Source Control Manager with all remote changes (if any) selected, ready to pull using Get Latest. When Source Control Manager is already open, this option refreshes it and selects all remote database changes. |
| Unit Test > Add New Test | Opens the Add New Test dialog to create a unit test for a specific database. |
| Unit Test > View Test List | Opens the Test List Manager, where you can view unit tests in the database. |
| Unit Test > Run All Tests | Runs all tests for the selected database and displays test results in the Test Results pane. |
| Show Details | Opens Object Viewer that displays object details. |
| Refresh | Updates the object list to reflect the latest changes. Shortcut: F5 |
Note
The Source Control shortcut menu is available only after you link the corresponding database to a source-control system.