The basic syntax for creating a DDL trigger follows:
The best way to illustrate the use of the DDL trigger syntax and power of these triggers is to look at a few examples. The example shown in Listing 30.14 illustrates the creation of a DDL trigger that is scoped at the database level and prevents table-level changes.
This trigger is fired whenever the
DROP TABLE statements are executed. Consider, for example, the following statements that can be run ...