View trigger:

A trigger can be viewed by using sp_helptrigger syntax. This returns all the triggers defined in a table.

Sp_helptrigger table_name

Drop a trigger

Syntax: DROP TRIGGER Trigger_name

Disable a trigger:-

Syntax: DISABLE TRIGGER [schema name] trigger name

ON [object, database or ALL server ]