Cascade delete is happening even though there is no foreign key relationship between 2 tables : VistaDB Support Center

How can we help you today?

Start a new topic

Cascade delete is happening even though there is no foreign key relationship between 2 tables

Murali K

started a topic almost 9 years ago

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

1 Comment

David McCallum

said almost 9 years ago

Can you attach a sample of your data that demonstrates this?