| Subject | Foreign key without name |
|---|---|
| Author | Nico Callewaert |
| Post date | 2010-03-25T15:39Z |
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]
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]