DDL Triggers in SQL Server :-
- It is introduced from sql server 2005.
- This triggers are created to control DDL operations like create,alter,drop.
Syntax :– create trigger <name>
On database
After create ,alter,drop
As
Begin
Statements
End
Example :- Create trigger trg10
On database
After create create_table
As
Begin
Print ‘table is created’
End.
↓
Insert table xyz(x int)
↓
Table is created
How many instead of insert trigger can be created on a table ?
Answer:- one
| Drop trigger trg1 |