>> 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.

Hi Martijn, Milan,

Thanks a lot for the reply. Normally no FK has to be dropped, but in case there is a mistake and one has to be dropped, this means trouble.
So, I will alter my design and name everything...

Thanks a lot for the clarification !
Nico


[Non-text portions of this message have been removed]