Database Reference
In-Depth Information
Figure 7.15
Test modiied AFTER Trigger.
Figure 7.16
Delete trigger using DROP TRIGGER.
Figure 7.17
Create and test DDL trigger.
In the above syntax, the capital letter words are the actual keywords used in the statement,
and lower case words are meanings of the content. To illustrate the use of DDL triggers, we will
irst create a table TESTING. hen, create a DDL trigger ired by the DROP_TABLE event. he
SQL statement DROP TABLE is then used to test the DDL trigger. Figure 7.17 shows how a DDL
trigger is created and used with the DDL command DROP TABLE.
