Cascade delete - SQL Server

refer to : http://stackoverflow.com/questions/6260688/how-do-i-use-cascade-delete-with-sql-server

use chsA

ALTER TABLE FCCSERVICECALLDETAIL 

ADD CONSTRAINT FK_FCCSERVICECALLDETAIL_FCCSERVICECALLDETAIL_Cascade

FOREIGN KEY (callid) REFERENCES call(callID) ON DELETE CASCADE

------------------------------

USE [CHSA]
GO
ALTER TABLE [dbo].[FCCSERVICECALL]  WITH NOCHECK ADD  CONSTRAINT [FK_FCCSERVICECALL_CALL] FOREIGN KEY([CALLID])
REFERENCES [dbo].[CALL] ([CALLID])
ON UPDATE CASCADE
ON DELETE CASCADE
NOT FOR REPLICATION 
GO
ALTER TABLE [dbo].[FCCSERVICECALL] CHECK CONSTRAINT [FK_FCCSERVICECALL_CALL]