title: Get information to create ALTER TABLE ADD FOREIGN KEY
body: <p>How to get the information to update an already existing foreign key..</p>
  
  <p>When updating a foreign key referemce in phpmyadmin this query is sent to the server</p>
  
  <pre><code>ALTER TABLE `dimension` ADD FOREIGN KEY (`test_id`) REFERENCES `db`.`test`
  (`id`) ON DELETE CASCADE ON UPDATE RESTRICT;
  </code></pre>
  
  <p>But how do I get the status <code>ON DELETE</code> and <code>ON UPDATE</code> to sending and updating the alter table query?</p>