TR_USR_QUERYVIEWTESTCODE_DELETE_BBNCCODETABLEIDMAP (Trigger)

create trigger TR_USR_QUERYVIEWTESTCODE_DELETE_BBNCCODETABLEIDMAP on dbo.USR_QUERYVIEWTESTCODE after delete not for replication as begin delete from dbo.BBNCCODETABLEIDMAP where CODETABLECATALOGID = '19a3062b-17c4-48de-8f64-49c08226e197' and TABLEENTRYID in (select ID from deleted) end