Rahul Chavan
Can we have trigger on DDL statements?
By Rahul Chavan in Databases & DBA on Apr 07 2016
  • Gajendra Jangid
    Jan, 2018 29

    yes

    • 1
  • Mukesh Kumar
    Sep, 2017 2

    Yes

    • 1
  • Shalu Shalini
    Apr, 2017 1

    yes we can use

    • 1
  • Vimal Lohani
    Feb, 2017 16

    Yes we can have triggers for DDL statements Create TRIGGER [SchemaChange_DDL]ON ALL SERVER FOR CREATE_TABLE, ALTER_TABLE, DROP_TABLE As Begin --Your code End

    • 1
  • Rahul Chavan
    Apr, 2016 7

    Yes we can have triggers on both DML and DDL statements. These trigger are called as DDL triggers.

    • 1


Most Popular Job Functions


MOST LIKED QUESTIONS