Chapter 29. Data definition triggers
After completing this chapter, you will be able to
Explain the different types of triggers.
Create, alter, and drop triggers.
Explain practical uses of triggers.
Data definition triggers, which differ from data manipulation triggers, fire based on events that occur at the server and database level. For example, you can create a data definition trigger that will fire when a database or table is created. These triggers are commonly used for auditing the creation of databases on a server or objects within a database. In addition, they can be used as a means of governing when tables, views, procedures, and other objects are created and for controlling naming conventions for particular objects and object types. Moreover, ...
Get Microsoft® SQL Server® 2012 Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
