Creating a report on existing triggers
Taking on the responsibility of administrating the database for the Fresh Fruit Delivery company also means keeping an eye on existing triggers.
The best approach is to have a report that can be run regularly and outputs details of the existing triggers.
This will ensure you have a good overview of the triggers and give you access to some interesting information.
Este ejercicio forma parte del curso
Building and Optimizing Triggers in SQL Server
Ejercicio interactivo práctico
Prueba este ejercicio completando el código de muestra.
-- Get the column that contains the trigger name
SELECT ___ AS TriggerName,
parent_class_desc AS TriggerType,
create_date AS CreateDate,
modify_date AS LastModifiedDate,
is_disabled AS Disabled,
-- Get the column that tells if it's an INSTEAD OF trigger
___ AS InsteadOfTrigger
FROM sys.___;