Answer:
Yes. They can be defined with create, alter, drop and other DDL statements.
For an example :
CREATE TRIGGER DDL_Trigger
ON DATABASE
FOR DROP_TABLE, ALTER_TABLE, CREATE_TABLE
AS
PRINT 'Get permissions to drop/alter/create table!!'
ROLLBACK ;
Asked In: Many Interviews |
Alert Moderator