InnoDB Table Type and Cascading Delete

[Admin]

If you try to alter tables type InnoDB and create a relationship between key fields for a cascading delete, you may get this error:

#1050 ...... error 150

What this means is:

SQLCODE -150, Error: THE OBJECT OF THE INSERT, DELETE, OR UPDATE STATEMENT IS A VIEW OR TRANSITION TABLE FOR WHICH THE REQUESTED OPERATION IS NOT PERMITTED

How you fix it is:

This relationship for cascading delete requires that all key fields are set to the same type and length and the tables are set to the InnoDB storage engine. If not, the above error results.

[Admin]

Here is sql code to relate tables together and cause a cascade delete with a single delete command:

ALTER TABLE table_name_1 ADD FOREIGN KEY(id) REFERENCES table_name_2(id) ON DELETE CASCADE;

Note: both tables must be InnoDB type