
Diagram and Modify a Database #74
Chapter 9, Server Explorer Hacks
|
305
HACK
Just as with tables, you can design a view by right-clicking on it and choos-
ing Design View. The design view is shown in Figure 9-12.
Much like the table designer, the view designer is very similar to the one in
Enterprise Manager. You can also add triggers to the view by right-clicking
on the view and clicking Add Trigger.
Stored Procedures
Support for stored procedures is one area in which the Server Explorer
excels. The Server Explorer displays not only the name of the stored proce-
dure, but also includes a list of the parameters and return columns from the
stored procedure. This node is shown in Figure 9-13.
From the Server Explorer, you can create new stored procedures, edit stored
procedures, and even run them. By right-clicking on the stored procedure
and choosing Run Stored Procedure, you will then see the parameters dia-
log shown in Figure 9-14.
Figure 9-9. Server Explorer Tables interface