

CREATE TRIGGER Interdire_Suppression ON dbo.iris_donnes
       INSTEAD OF DELETE
AS 
BEGIN
   PRINT 'Vous ntes pas autoris  supprimer' 
END
GO

----------------

DELETE FROM [dbo].[iris_donnes]
      WHERE [Spales.Longueur] < 6
GO