Delete em cascata

ALTER TABLE [dbo].[TB_FW_TransacaoGrupo] WITH CHECK ADD CONSTRAINT [FK_TB_FW_TransacaoGrupo_TB_FW_Transacao] FOREIGN KEY([ID_TRANSACAO])
REFERENCES [dbo].[TB_FW_Transacao] ([ID_TRANSACAO])
ON DELETE CASCADE
GO

ALTER TABLE [dbo].[TB_FW_TransacaoGrupo] CHECK CONSTRAINT [FK_TB_FW_TransacaoGrupo_TB_FW_Transacao]
GO