polilop wrote:
> In my database i have a table that contains topics and it is related to
> another table which contains subtopics. What i have to do is delete a record
> in the topics but i allso have to delete the related records in the sub
> topics (as they are related). Is there a easier way to do this then having
> to first delete the subtopics and then delete the topics records?

"polilop" <fmatosic@inet.hr> wrote in message
news:ejkgmbt7FHA.1188@TK2MSFTNGP12.phx.gbl...
> They use foreign keys to enforce referential integrity, thats why i cannot
> delete a record from table topics if it has a record in the table subtopic
,
> becouse subtopic contains the foreign key topics. But what i have to do is
> delete a record from topics table and allso if it has a subtopic, delete
it
> allso. Is there a way to delete them both without having to delete the
> record from the subtopic and then delete the related topic record???
>
>
>
> "Mighty Chaffinch" <MightyChaffinch@hotmail.com> wrote in message
> news:%232xejas7FHA.2384@TK2MSFTNGP12.phx.gbl...
> > polilop wrote:
> >> In my database i have a table that contains topics and it is related to
> >> another table which contains subtopics. What i have to do is delete a
> >> record in the topics but i allso have to delete the related records in
> >> the sub topics (as they are related). Is there a easier way to do this
> >> then having to first delete the subtopics and then delete the topics
> >> records?
> >
> > Use foreign keys to enforce referential integrity, if your DBMS supports
> > this.
> >
> > MC
>
>

"Mighty Chaffinch" <MightyChaffinch@hotmail.com> wrote in message
news:%232xejas7FHA.2384@TK2MSFTNGP12.phx.gbl...
> polilop wrote:
>> In my database i have a table that contains topics and it is related to
>> another table which contains subtopics. What i have to do is delete a
>> record in the topics but i allso have to delete the related records in
>> the sub topics (as they are related). Is there a easier way to do this
>> then having to first delete the subtopics and then delete the topics
>> records?
>
> Use foreign keys to enforce referential integrity, if your DBMS supports
> this.
>
> MC