DDL Event Groups for Use with Event Notifications

Updated: 14 April 2006

The following diagram lists the DDL event groups that can be used to run an event notification, and also the Transact-SQL statements they cover. Note the inclusive nature of the event groups, as indicated by the tree structure of the diagrams. For example, an event notification that specifies FOR DDL_TABLE_EVENTS covers the CREATE TABLE, ALTER TABLE and DROP TABLE Transact-SQL statements, while an event notification that specifies FOR DDL_TABLE_VIEW_EVENTS covers all Transact-SQL statements under DDL_TABLE_EVENTS, DDL_VIEW_EVENTS, DDL_INDEX_EVENTS, and DDL_STATISTICS_EVENTS.

Certain system stored procedures that perform DDL-like operations can also fire event notifications. Test your event notifications to determine their responses to system stored procedures that are run. For example, the CREATE TYPE statement and sp_addtype stored procedure will both fire an event notification that is created on a CREATE_TYPE event. However, the sp_rename stored procedure does not fire any event notifications.

DDL event groups for use with event notifications

Release History

14 April 2006

New content:
  • Added a note that recommends testing event notifications to determine their responses to stored procedure that are executed.

Community Additions