How do I know if a database trigger is DROP_TABLE or ALTER_TABLE?

Question

If I create a database trigger in SQL Server 2008 which triggers on both DROP_TABLE and ALTER_TABLE, how do I determine whether this is a DROP or an ALTER?

Answer 1

Inside the trigger you can test

SELECT EVENTDATA().value('(/EVENT_INSTANCE/EventType)[1]','sysname')

It will be DROP_TABLE or ALTER_TABLE

Documentation for EVENTDATA