Tracking table changes
You need to create a new trigger at the database level that logs modifications to the table TablesChangeLog.
The trigger should fire when tables are created, modified, or deleted.
Este ejercicio forma parte del curso
Building and Optimizing Triggers in SQL Server
Instrucciones del ejercicio
Create the new trigger following the company's requirements.
Ejercicio interactivo práctico
Prueba este ejercicio completando el código de muestra.
-- Create the trigger to log table info
CREATE TRIGGER TrackTableChanges
ON ___
FOR CREATE_TABLE,
___,
DROP_TABLE
AS
INSERT INTO ___ (EventData, ChangedBy)
VALUES (EVENTDATA(), USER);