Database Reference
In-Depth Information
Figure 8.16
Drop view with GUI tool.
1. Assume that the Windows Azure SQL Database portal is still open. Click the
Design
icon on the left-hand side of your screen. hen, click the
Views
tab. You should be able
to see the existing views. Select the view
STUDENT_GR ADE_VIEW
and click the
Drop view
button as shown in Figure 8.16. hen Click
OK
.
2. Another way to drop the view is to use the DROP VIEW statement. To drop the view
Student_GRADE_VIEW, enter the following SQL statement:
DROP VIEW STUDENT_GRADE_VIEW
3. Highlight the code and click
Run
. As shown in Figure 8.17, the view is dropped
successfully.
4. To verify that STUDENT_GRADE_VIEW is dropped, log of Windows Azure SQL
Database and log on again. Click the
Design
icon and click the
Views
tab. As shown
in Figure 8.18, the view STUDENT_GRADE_VIEW is not there anymore.
Figure 8.17
Drop view with SQL statement.
