Delete all views from sql server database with Query

Introduction: 

In this article i will explain how to delete all the views from Sql server database.

We can delete all views by executing single query. We don’t need to execute different query for each View.

Note: This command will delete all the views from your database.

Read More

How to delete all triggers from sql server database

Introduction: 

 In this article i will explain how to delete all the triggers from Sql Server database. If we want to delete all triggers from our database, then we can done it by using single query.

Note: This command will delete all the triggers from your database so use this command with care.

Implementation: In Sql server execute the following command:

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

Read More