Re: [SQL] finding if a foreign key is in use

2004-07-01 Thread Achilleus Mantzios
O kyrios Phil Endecott egrapse stis Jul 1, 2004 : > >>>in my app i have a table where the id serves as a foreign key for > >>>one or more other tables. if i want to delete a row in the table, > >>>i currently search the other tables where this table is referenced > >>>to see if the row is in use -

Re: [SQL] finding if a foreign key is in use

2004-07-01 Thread Phil Endecott
in my app i have a table where the id serves as a foreign key for one or more other tables. if i want to delete a row in the table, i currently search the other tables where this table is referenced to see if the row is in use - and then, if not in use, permit deletion. Now if i want the delete but

Re: [SQL] finding if a foreign key is in use

2004-07-01 Thread Stephan Szabo
On Thu, 1 Jul 2004, Kenneth Gonsalves wrote: > On Tuesday 29 June 2004 07:19 pm, Phil Endecott wrote: > > Kenneth Gonsalves <[EMAIL PROTECTED]> wrote: > > > in my app i have a table where the id serves as a foreign key for > > > one or more other tables. if i want to delete a row in the table, > >

Re: [SQL] finding if a foreign key is in use

2004-06-30 Thread Kenneth Gonsalves
On Tuesday 29 June 2004 07:19 pm, Phil Endecott wrote: > Kenneth Gonsalves <[EMAIL PROTECTED]> wrote: > > in my app i have a table where the id serves as a foreign key for > > one or more other tables. if i want to delete a row in the table, > > i currently search the other tables where this table

Re: [SQL] finding if a foreign key is in use

2004-06-29 Thread Phil Endecott
Kenneth Gonsalves <[EMAIL PROTECTED]> wrote: > in my app i have a table where the id serves as a foreign key for > one or more other tables. if i want to delete a row in the table, > i currently search the other tables where this table is referenced > to see if the row is in use - and then, if not

[SQL] finding if a foreign key is in use

2004-06-28 Thread Kenneth Gonsalves
in my app i have a table where the id serves as a foreign key for one or more other tables. if i want to delete a row in the table, i currently search the other tables where this table is referenced to see if the row is in use - and then, if not in use, permit deletion. Now if i want the delete