TR_CONSTITUENCYCODE_DELETECONSTITUENCYDEFINITION

create trigger TR_CONSTITUENCYCODE_DELETECONSTITUENCYDEFINITION on dbo.CONSTITUENCYCODE after delete not for replication
as
begin
    set nocount on;

        delete from
            dbo.CONSTITUENCYDEFINITION
        where 
            ID in (
                select ID from DELETED
            );

end