TR_CODETABLECATALOG_DELETE_BBNCCODETABLECATALOGIDMAP

                create trigger TR_CODETABLECATALOG_DELETE_BBNCCODETABLECATALOGIDMAP on dbo.CODETABLECATALOG after delete not for replication
                as begin
                    delete from dbo.BBNCCODETABLECATALOGIDMAP 
                        where CODETABLECATALOGID in (select ID from deleted)
                end