Drop all Triggers belonging to any schema in SQL Server

How to drop all triggers in a SQL Server database:

Drop all Triggers belonging to any schema :

In this post we want to delete all triggers from specific sql database. For this we use cursor . if you don’t know about sql server cursor then visit fallowing post:

·    Sql server cursor declaration syntax example

·    Sql server –Example of sql cursor with syntax

Drop Triggers from SQL Server databse:

Declare my_cursor Cursor For Select [name] From sys.objects where type = 'tr'

Open my_cursor

Fetch Next From cur Into @trgName

      While @@fetch_status = 0

        Begin

             -- for delete or drop all trigger from database.

               Exec('drop trigger ' + @trgName)

             -- find the newxt trigger

              Fetch Next From my_cursor Into @trgName

        End

      Close my_cursor

            -- After complete the work relise the memory occupied by cursor.

Deallocate my_cursor

Sql Server Interview Qus:

• SQL Server questions for interview

• Overview of Sql

• Sql server while loop

• Continue Statement in sql

• SQL Parameter how to use in asp.net

• SQL-QUERY TYPES, ALIASES, JOINS, CLAUSES, FUNCTIONS

• Sql-determine the version and edition of SQL Server

• Sql -Stored procedure how to use

• Different Types of SQL Server Stored Procedures

• SQL-Create Stored Procedure in SQL Server:

• SQL Server -Create Stored Procedure with Parameter

• How to Create Sql Function,

• SQLInjection, prevent asp.net web application

• SQL Server- Database Backup and Restore History

• SQL Server -Create Stored Procedure with Parameter

• Sql server cursor declaration syntax example

• SQL Server - Copy data from one database to another data base

• What is the difference between WCF and ASMX Web Services?