Copy Code Trigger Definition 

        
CREATE trigger TR_CONSTITUENCYSYSTEMNAME_DELETE on dbo.CONSTITUENCYSYSTEMNAME
for delete
not for replication
as begin
  set nocount on;

  if dbo.UFN_CONSTITUENCYSYSTEMNAME_ALLROWSEXIST() <> 1 begin
    rollback tran
    raiserror('A row is required to be in the table for each system constituency.',16,10)
  end
end