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