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.
Latihan ini adalah bagian dari kursus
Building and Optimizing Triggers in SQL Server
Petunjuk latihan
Create the new trigger following the company's requirements.
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
-- Create the trigger to log table info
CREATE TRIGGER TrackTableChanges
ON ___
FOR CREATE_TABLE,
___,
DROP_TABLE
AS
INSERT INTO ___ (EventData, ChangedBy)
VALUES (EVENTDATA(), USER);