How can we help you today?
Cascade delete is happening even though there is no foreign key relationship between 2 tables
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.
ID, Name, AddressID, Email
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
Can you attach a sample of your data that demonstrates this?