Subject | foreign Key Deletion |
---|---|
Author | Maurizio P. |
Post date | 2006-08-17T21:21:19Z |
hi ,
i searched hours , but i could not find any help so
i try to ask here (my first time) for an help :
i thought that normally it would not be possible to
delete a row which is a foreign key in another table ,
the example :
tableBanks
-idBAnk(PK)
-desBAnk
tableCustomers
-idCustomer(PK)
-desCustomer
-idBank (FK)
..ecc
in this situation i can delete every tableCustomer row , even if them
exists as FK in the second table ,
is it the normal behave ? how can i prevent it ?
i am using Firebird 1.5 with delphi , and i use IBExper for
the database design .
thanks
Mauro
[Non-text portions of this message have been removed]
i searched hours , but i could not find any help so
i try to ask here (my first time) for an help :
i thought that normally it would not be possible to
delete a row which is a foreign key in another table ,
the example :
tableBanks
-idBAnk(PK)
-desBAnk
tableCustomers
-idCustomer(PK)
-desCustomer
-idBank (FK)
..ecc
in this situation i can delete every tableCustomer row , even if them
exists as FK in the second table ,
is it the normal behave ? how can i prevent it ?
i am using Firebird 1.5 with delphi , and i use IBExper for
the database design .
thanks
Mauro
[Non-text portions of this message have been removed]