View Existing Triggers – Drop One or More Triggers in Sql Server 2005

To view the existing triggers in the database

SELECT * FROM sys.triggers
OR
SELECT * FROM sysobjects WHERE xtype='TR'

To view the existing triggers in a specified table

sp_helptrigger tablename

To drop a trigger

DROP TRIGGER triggername

To drop more triggers at a time

DROP TRIGGER [trigger1],[trigger2],[trigger3]...[triggern]

Popularity: 12% [?]

Related posts:

  1. Sql Server Interview Questions – Part 1
  2. Using OVER() with Aggregate Functions in Sql Server 2005
  3. CASE Function in SQL Server 2005
  4. Create Database,Table and Procedure in Sql Server – Beginners
  5. Check Sql Server database is Case Sensitive or Insensitive (Collation)
You can leave a response, or trackback from your own site.

Leave a Reply

Designed by: Business Web Hosting | Thanks to Buy Icons, travel tips and Used Cars