Database Reference
In-Depth Information
Figure 8.11
New row being deleted from STUDENT_GRADE_VIEW.
8. Highlight the code and click
Run
. To see what has happened to the view STUDENT_
GRADE_VIEW, enter the following query statement. As shown in Figure 8.11, the
new role is deleted from the view.
9. To verify if the row is deleted from the table STUDENT_CLASS, run the SELECT *
FROM STUDENT_CLASS statement. he result shown in Figure 8.12 indicates that
the row is no longer in the table STUDENT_CLASS.
Figure 8.12
New row being deleted from STUDENT_CLASS table.
