alter a constraint to add Delete Cascade

[rewdee]

I have a foreign key constraint on a table that references another. I want to add Delete Cascade & Update Cascade. How do I do that? Do I drop the constraint and add a new one with ON DELETE Cascade or is there some way to alter table alter column blah blah?

Thanks,
Rewdee

 

[rewdee]

Any suggestions on this one. I can't even get the adding and deleting constraint idea going.

I've tried:

ALTER TABLE [dbo].[Table1] 
        DROP CONSTRAINT [FK_Table1_Table2] 
        Constraint [FK_Table1_Table2] FOREIGN KEY     
	(
		[ID]
	) REFERENCES [dbo].[Table2] (
		[ID]
	) ON DELETE CASCADE  ON UPDATE CASCADE 
GO

I'm desperate on this one. Any help would be appreciated.

Thanks,
Rewdee

 

[vongrunt]

Try simply:

ALTER TABLE [dbo].[Table1] 
        DROP CONSTRAINT [FK_Table1_Table2]

 

[rewdee]

Thanks, vongrunt for your reply.

It wasn't exactly what I needed because I wanted to modify the constraint but I did get it as:

ALTER TABLE [dbo].[Table1] 
        DROP CONSTRAINT [FK_Table1_Table2] 
        
GO

ALTER TABLE [dbo].[Table1] 
ADD Constraint [FK_Table1_Table2] FOREIGN KEY     
	(
		[ID]
	) REFERENCES [dbo].[Table2] (
		[ID]
	) ON DELETE CASCADE  ON UPDATE CASCADE

It ain't pretty but it works.

Thanks,
Rewdee