TR_CONSTITUENCYSYSTEMNAME_DELETE (Trigger)

            -- replace trigger
            create trigger [dbo].[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

            EXEC sys.sp_addextendedproperty @name=N'BB_IsSystem', @value=N'1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CONSTITUENCYSYSTEMNAME', @level2type=N'TRIGGER',@level2name=N'TR_CONSTITUENCYSYSTEMNAME_DELETE'
            EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'This trigger keeps a row from being deleted if it will break CK_CONSTITUENCYSYSTEMNAME_ALLROWSEXIST.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CONSTITUENCYSYSTEMNAME', @level2type=N'TRIGGER',@level2name=N'TR_CONSTITUENCYSYSTEMNAME_DELETE'