Managing Database Items
Database items are the objects that you work on SQL Server database.
SQLSourceSafe supports 4 types of database items:
- Tables
(includes Indexes/Keys, Triggers, and Constraints)
- Views
- Stored
Procedures
- User
Defined Functions
They are accessible through Tables, Views, Stored Procedures, and User defined Functions category nodes in the tree display structure.
Figure 1. Application Main Window that displays Stored
Procedures, Tables, User Defined Functions and Views nodes.
From Figure 1, we will see that the checked out database
item are displayed in color red. The checked in database items are displayed in
black color. The new database items (not in SourceSafe database yet) are in
blue color.
Create, Edit, Browse and Remove database items
Create: Select Stored procedures, Tables, User Defined
Functions or Views category node. Then right click on the node and select Add
New… of the context menu.
Edit: For database item in the SQL Server Pane that is Red
(Checked Out) or Blue (Newly Created) color, double click on the item or right click
on the item and then select Properties/Edit from the context menu.
Browse: Database items in Black color in the SQL Server Pane
means the item is not checked out for editing. This database item is in READ
ONLY mode. Double click on the item or right click on the item and select Properties/Edit
from the context menu.
Remove: Select the database item in the SQL Server Pane that
you want to remove. Then right click on the item and select DELETE from the
menu.