Eliminare e modificare i trigger

Creare e ottimizzare i trigger in SQL Server

Florin Angelescu

Instructor

Eliminare i trigger di tabelle e viste

DROP TRIGGER PreventNewDiscounts;

Tabella

DROP TRIGGER PreventNewDiscounts;

DROP TRIGGER PreventViewsModifications
ON DATABASE;

Tabella

Database

DROP TRIGGER PreventNewDiscounts;

DROP TRIGGER PreventViewsModifications
ON DATABASE;

DROP TRIGGER DisallowLinkedServers
ON ALL SERVER;

Tabella

Database

Server

DISABLE TRIGGER PreventNewDiscounts
ON Discounts;

DISABLE TRIGGER PreventViewsModifications
ON DATABASE;

DISABLE TRIGGER DisallowLinkedServers
ON ALL SERVER;

Tabella

Database

Server

ENABLE TRIGGER PreventNewDiscounts
ON Discounts;

ENABLE TRIGGER PreventViewsModifications
ON DATABASE;

ENABLE TRIGGER DisallowLinkedServers
ON ALL SERVER;

Tabella

Database

Server

CREATE TRIGGER PreventDiscountsDelete
ON Discounts
INSTEAD OF DELETE
AS
    PRINT 'Non ti è consentito eliminare dati dalla tabella Discounts.';

DROP TRIGGER PreventDiscountsDelete;

CREATE TRIGGER PreventDiscountsDelete
ON Discounts
INSTEAD OF DELETE
AS
    PRINT 'Non ti è consentito rimuovere dati dalla tabella Discounts.';

CREATE TRIGGER PreventDiscountsDelete
ON Discounts
INSTEAD OF DELETE
AS
    PRINT 'Non ti è consentito eliminare dati dalla tabella Discounts.';

ALTER TRIGGER PreventDiscountsDelete
ON Discounts
INSTEAD OF DELETE
AS
    PRINT 'Non ti è consentito rimuovere dati dalla tabella Discounts.';

Creare e ottimizzare i trigger in SQL Server