on delete cascade

[smartipants2002]

I have a table named post where in the postid field is the primary key field and in that same table the response field is the foreign key field to the postid field.
Now my question is how can i implement delete cascade on them through code? Of course i am using Microsoft SQL Server.

Please help.It is urgent.
Thanks

 

[bperry]

Interested readers may like to review thread220-260448 to get some additional background on this discussion.


sp2002:
I'm leaning toward the suggestion re: adding a new column to the table. How would you feel about that?
-------------------------------
bperry