From the course: SQL Server Database Triggers
Unlock the full course today
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
View all triggers in a database - SQL Server Tutorial
From the course: SQL Server Database Triggers
View all triggers in a database
- Triggers execute silently and often with no visible indication that they fired. So it's hard to tell when a command has been intercepted by a trigger, because of this, it's important to keep track of what triggers are in the database and know what they're doing. SQL server provides to catalog views that we can use to see what triggers are present in our databases. The first one I want to take a look at is sys.triggers. I'm going to run line number one here that just says select star from sys.triggers to see what it contains. Now, your results might look a little different from mine, depending on whether you've actually gone through and created all the different triggers throughout this course and whether you've gone through and deleted them as well. But these are the results that I'm currently seeing inside of my Connecticut TRG database. The first couple of columns, just give me the name of the trigger as well as internal…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.