Hello Nico,

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

You cannot drop the constraint if you don't know it's name.

> Many thanks in advance...

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com