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, i

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

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 - and then, if

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 is

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 in

[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