Listing All Triggers in the SQL Server

文章推薦指數: 80 %
投票人數:10人

This tutorial shows you how to list all triggers in SQL Server by querying data from the sys.triggers view. SkiptocontentHome»SQLServerTriggers»SQLServerListAllTriggersTolistalltriggersinaSQLServer,youquerydatafromthesys.triggersview:SELECT name, is_instead_of_trigger FROM sys.triggers WHERE type='TR';Codelanguage:SQL(StructuredQueryLanguage)(sql)Thefollowingpictureshowstheoutput:PreviouslySQLServerViewTriggerDefinitionUpNextSQLServerDROPTRIGGERSearchfor:GettingStartedTriggers



請為這篇文章評分?