"Roji. P. Thomas" <thoasroji_no_spam_@gmail.com> wrote in message
news:Og5VKEvxEHA.3096@tk2msftngp13.phx.gbl...
> See ON DELETE CASCADE in BOL
>
> --
> Roji. P. Thomas
> Net Asset Management
> https://www.netassetmanagement.com
>
>
> "John Rugo" <jrugo@patmedia.net> wrote in message
> news:uLwggqtxEHA.2876@TK2MSFTNGP12.phx.gbl...
>> Hi All,
>> Is there a simple way of deleting records in one table and also those
>> tables related in another table.
>>
>> Create Table Table1
>> (PID VarChar(50),
>> RID VarChar(50))
>>
>> Create Table Table2
>> (RID VarChar(50))
>> ---------------------------
>>
>> DELETE FROM Table1
>> WHERE PID = @pidValue
>>
>> /*Now I want to delete the records in Table2 that are related by the RID
>> column in both.*/
>>
>> I know this can be done but I'm really tired and my head hurts :(
>> Any Ideas would be greatly appreciated.
>>
>> Thanks,
>> John.
>>
>>
>>
>>
>
>

"John Rugo" <jrugo@patmedia.net> wrote in message
news:uLwggqtxEHA.2876@TK2MSFTNGP12.phx.gbl...
> Hi All,
> Is there a simple way of deleting records in one table and also those
> tables related in another table.
>
> Create Table Table1
> (PID VarChar(50),
> RID VarChar(50))
>
> Create Table Table2
> (RID VarChar(50))
> ---------------------------
>
> DELETE FROM Table1
> WHERE PID = @pidValue
>
> /*Now I want to delete the records in Table2 that are related by the RID
> column in both.*/
>
> I know this can be done but I'm really tired and my head hurts :(
> Any Ideas would be greatly appreciated.
>
> Thanks,
> John.
>
>
>
>