Check out example codes for "Find all triggers in database". It will help you in understanding the concepts better.

Code Example 1

SELECT  
    name,
    is_instead_of_trigger
FROM 
    sys.triggers  
WHERE 
    type = 'TR';

Learn ReactJs, React Native from akashmittal.com