How can we help you today?
Cascade delete is happening even though there is no foreign key relationship between 2 tables
1 Comment
Can you attach a sample of your data that demonstrates this?
Can you attach a sample of your data that demonstrates this?
Murali K
Hi,
Lets say there are two tables Student and Address. There are no foreign key relationship between the two tables. Let me give the sample structure.
Student TABLE
ID, Name, AddressID, Email
Address TABLE
AddressID, DoorNo, Street, City, Country
The problem here is whenever I delete a record from the Student table the related entry in Address table is also getting deleted even though there is no foreign key reference.
We have thoroughly verified our dbschema scripts, there are no foreign key references. Let us know if we have to do something special in VistaDB for this.
Thanks In Advance
Murali