If you control the way your users create those foreign keys, maybe you
can force the username/tablename/fieldname in this keyname?

Just an idea.

John


Nico Callewaert wrote:

> Hi list,
>
> What if you create a table with a foreign key like this :
>
> AFIELD NOT NULL REFERENCES ATABLE(......
>
> Is this good practice ? At least it's easy and short syntax...
>
> What if ever the Foreign key has to be deleted through a script, could it be that this will be big trouble ?
> I know it's easy to delete with a administrators GUI. But what if it has to be deleted through a script, is that possible without knowing the name ? Customer A could have a INTEG_xxx that is different from customer B...
>
> Many thanks in advance...
> N.
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>

--
John vd Waeter
www.jvdw.nl
www.gps-carpool.net
www.shotinthedark.nl
www.pdaforms.nl
www.dbapocket.nl

john@...