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

Forums | Webyog

Tools to manage and monitor MySQL databases

On Delete Action Lost On Foreign Key

This topic is empty.

Viewing 3 reply threads

Author

Posts
- July 23, 2016 at 10:47 pm #13550
  
  ErikEgon
  Member
  
  Hi,
  
  On defining foreign keys the ON DELETE setting RESTRICT is lost on save.
  
  After save:
  
  The constraint has also been moved to a strange position, if ordered by Constraint Name.
  
  Regards,
  
  Erik.
- July 25, 2016 at 7:45 am #35749
  
  Sibin A S
  Moderator
  
  Hi,
  
  Can you please tell us your MySQL server version and also SQLyog version?
  
  Regards,
  
  Sibin
- July 25, 2016 at 8:23 am #35750
  
  ErikEgon
  Member
  
  Sure, this is what is reported:
  
  SQLYog: 12.2.4
  
  MySQL: 5.5.50-0ubuntu0.14.04.1
  
  I have seen this behavior more often over the past months (years?), but too lazy to report.
  
  Erik.
- July 25, 2016 at 11:47 am #35751
  
  Sibin A S
  Moderator
  
  Hi Erik,
  
  SQLyog reads and presents the DDL information which is returned by executing SHOW CREATE TABLE query of the respective table. It can also be verified by executing the same command (SHOW CREATE TABLE…) from the command line and you may find that the constraint RESTRICT is simply not recorded by the server.
  
  RESTRICT is default action and it does not matter if it is recorded server-side or not. Any other action then RESTRICT should be recorded of course. Therefore for an ON DELETE or ON UPDATE that is not specified, the default action is always RESTRICT.
  
  Regards,
  
  Sibin
Author

Posts

Viewing 3 reply threads

You must be logged in to reply to this topic.