TR_ATTRIBUTECATEGORY_DELETE_BBNCATTRIBUTECATEGORYIDMAP

                    CREATE trigger TR_ATTRIBUTECATEGORY_DELETE_BBNCATTRIBUTECATEGORYIDMAP on dbo.ATTRIBUTECATEGORY after delete not for replication
                    as begin
                        delete from dbo.BBNCATTRIBUTECATEGORYIDMAP 
                            where ATTRIBUTECATEGORYID in (select ID from deleted)
                    end