Database Reference
In-Depth Information
Figure 7.33
Create Drop_Class trigger.
4. Highlight the code and click Run . As shown in Figure 7.34, the trigger Drop_
Class prevents the student with the id 12 from withdrawing all the classes without
approval.
In this hands-on activity, six tasks are carried out to demonstrate how to create, use, and
manage user-deined functions, stored procedures, and triggers. You have also learned how
to use the logical tables INSERTED and DELETED to implement INSTEAD OF and
AFTER triggers.
Figure 7.34
Test Drop_Class trigger.
Search WWH ::




Custom Search