TR_SOCIALMEDIAACCOUNTTYPECODE_DELETE_BBNCCODETABLEIDMAP

create trigger TR_SOCIALMEDIAACCOUNTTYPECODE_DELETE_BBNCCODETABLEIDMAP on dbo.SOCIALMEDIAACCOUNTTYPECODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '9c6ffb20-6f0f-43d4-ab3a-3bf5f1a87b1e' and TABLEENTRYID in (select ID from deleted) end