Monday, 6 April 2015

SQL SERVER - How to delete all triggers in database


Remove all Triggers
Go
    -- drop all user defined triggers
    Declare @trgName varchar(500)
    Declare cur Cursor For Select [name] From sys.objects where type = 'tr'
    Open cur
    Fetch Next From cur Into @trgName
    While @@fetch_status = 0
    Begin
    Exec('drop trigger ' + @trgName)
    Fetch Next From cur Into @trgName
    End
    Close cur
    Deallocate cur 

0 comments:

Post a Comment

Get Benifits