TR_EDUCATIONALHISTORYSTATUS_CHECKSYSTEMENTRIES

Definition

Copy


CREATE trigger dbo.TR_EDUCATIONALHISTORYSTATUS_CHECKSYSTEMENTRIES
  on dbo.EDUCATIONALHISTORYSTATUS
  after delete
  not for replication
as begin
  if (exists (select ID 
              from deleted 
              where ID in ('00000000-0000-0000-0000-000000000001'
                           '00000000-0000-0000-0000-000000000002'
                           '00000000-0000-0000-0000-000000000003'
                           '00000000-0000-0000-0000-000000000004')))
  begin
    raiserror('System educational history status entries cannot be deleted.',13,1);
  end
end