FOREIGN KEY constraint - Part II
Every was fine until this part,
ALTER TABLE sales ADD FOREIGN KEY (customer_id) REFERENCES Customers(customer_id) ON DELETE CASCADE
Error Code: 1824. Failed to open the referenced table 'customers'
1 answers ( 0 marked as helpful)
Submit an answer
Resolved: foreign key : able to see foreign key in the table sales DDL tab , but the Foreign Keys tab is empty