Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Foreign Key Constraints

forums › forums › SQLyog › Query Builder and Schema Designer › Foreign Key Constraints

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • April 5, 2011 at 8:00 am #32109
      ashwin
      Member
      Quote:
      (`db_logicold_ops`., CONSTRAINT `FK_tbl_batch_manifestProduct` FOREIGN KEY (`product_id`) REFERENCES `tbl_product` (`id`))

      This error means that there is data in the child table that is not present in the parent table and hence while trying to create a foreign key constraint between the two tables you are getting the above error.

      Please ensure that the column that you are trying to create the foreign key on has same data in both the child and the parent table and then try creating a constraint.

    • April 5, 2011 at 8:37 pm #32110
      Jim Emery
      Member
      'ashwin' wrote:

      This error means that there is data in the child table that is not present in the parent table and hence while trying to create a foreign key constraint between the two tables you are getting the above error.

      Please ensure that the column that you are trying to create the foreign key on has same data in both the child and the parent table and then try creating a constraint.

      Thanks for the help.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.