TR_VSECONSTITUENCY_DELETE

                    CREATE trigger TR_VSECONSTITUENCY_DELETE on dbo.VSECONSTITUENCY
                    for delete
                    not for replication
                    as begin
                        set nocount on;

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