SQL Script to find triggers in SQL Database
Sometime we need to find all the triggers defined on the database. So in this case, we can use the below SQL Query:-SELECT
tbl.name as [Table Name]
, trig.name as [Trigger Name]
, trig.is_disabled
FROM [sys].[triggers] as trig
INNER JOIN sys.tables as tbl
ON trig.parent_id = tbl.object_idIn case, if we need to find out all the triggers defined on a particular table then we can use the below SQL script
tbl.name as [Table Name]
, trig.name as [Trigger Name]
, trig.is_disabled
FROM [sys].[triggers] as trig
INNER JOIN sys.tables as tbl
ON trig.parent_id = tbl.object_idIn case, if we need to find out all the triggers defined on a particular table then we can use the below SQL script
SELECT
tbl.name as [Table Name]
, trig.name as [Trigger Name]
, trig.is_disabled
FROM [sys].[triggers] as trig
inner join sys.tables as tbl
on trig.parent_id = tbl.object_id
where tbl.name=’Tblname’
/* where Tblname name is the name of the table*/
Related article
SQL Triggers – An Introduction
Keep learning and don’t forget to gives feedback on the article. You can also send feedback to me on my mailid askvivekjohari@gmail.com
Share this:
Discover more from Technology with Vivek Johari
Subscribe to get the latest posts sent to your email.
… [Trackback]
[…] Find More Info here to that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Here you will find 60832 additional Information to that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Find More to that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Find More Info here on that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Info to that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Information on that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Here you can find 87123 more Info on that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Read More Info here on that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Read More to that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Find More here to that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Information to that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Read More on to that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Read More on to that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] There you will find 97864 additional Info to that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Find More Information here on that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Info on that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Find More to that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Find More on that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Here you can find 75819 more Information to that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] There you will find 32516 additional Information on that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Find More on that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] There you will find 46102 additional Info on that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Read More Information here on that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Read More on that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Find More Info here on that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Find More to that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Read More to that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Info to that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Find More here on that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]
… [Trackback]
[…] Here you can find 27312 more Information to that Topic: techmixing.com/2015/08/sql-script-to-find-all-triggers-defined.html […]