Sybase ASE Triggers

The following triggers are available in the database.

Trigger

Name: TRG_SUB_INSERT

Content:

CREATE TRIGGER TRG_SUB_INSERT ON SUBSCRIPTION FOR INSERT AS IF (SELECT COUNT(*) FROM SUBSCRIPTION, inserted WHERE SUBSCRIPTION.CODE = inserted.CODE AND SUBSCRIPTION.CODE IS NOT NULL AND SUBSCRIPTION.CODE != '') > 1 BEGIN RAISERROR 20000 'The subscription code is already in the subscription table' END GO