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.
Bu egzersiz
Building and Optimizing Triggers in SQL Server
kursunun bir parçasıdırEgzersiz talimatları
Create the new trigger following the company's requirements.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Create the trigger to log table info
CREATE TRIGGER TrackTableChanges
ON ___
FOR CREATE_TABLE,
___,
DROP_TABLE
AS
INSERT INTO ___ (EventData, ChangedBy)
VALUES (EVENTDATA(), USER);