Nico Callewaert wrote:

> What if you create a table with a foreign key like this :
>
> AFIELD NOT NULL REFERENCES ATABLE(......
>
> Is this good practice ?

No. You should name your constraints.

> What if ever the Foreign key has to be deleted through a script, could it be that this will be big trouble ?

Trouble? Yes. Big? It depends how much of your time you are willing to
spend researching the system tables and learning how admin. tools do it
and then replicate that into your upgrade scripts. If you use Firebird
1.x this would also require some programming because EXECUTE BLOCK is
not available.


--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================