![mysql - How do I change the definition of a primary key column that's involved in a botched foreign key constraint? - Database Administrators Stack Exchange mysql - How do I change the definition of a primary key column that's involved in a botched foreign key constraint? - Database Administrators Stack Exchange](https://i.stack.imgur.com/g2DJX.png)
mysql - How do I change the definition of a primary key column that's involved in a botched foreign key constraint? - Database Administrators Stack Exchange
![just three tables, I want to add a foreign key on product from supplier and it keeps making this error, although POS can easily get foreign keys but for some reason product just three tables, I want to add a foreign key on product from supplier and it keeps making this error, although POS can easily get foreign keys but for some reason product](https://preview.redd.it/just-three-tables-i-want-to-add-a-foreign-key-on-product-v0-346a9qhprc4c1.png?width=640&crop=smart&auto=webp&s=58a106c43260f19c735edf32ac1fff2162e0a30a)
just three tables, I want to add a foreign key on product from supplier and it keeps making this error, although POS can easily get foreign keys but for some reason product
![SQL SERVER - 2008 - Creating Primary Key, Foreign Key and Default Constraint - SQL Authority with Pinal Dave SQL SERVER - 2008 - Creating Primary Key, Foreign Key and Default Constraint - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/5_AllQuery.gif)