title: How can i see the definer of a table?
body: <p>I am currently trying to make a dump of my production database and deploy it in my development database.</p>
  
  <p>Before i do so, i am willing to add a script that will change the definer of the database's tables to a definer that is used in my development database after the deployment is complete.</p>
  
  <p>Is there a way to tell what is the current definer for a table?
  Iv'e tried <code>SHOW CREATE TABLE</code> but it doesn't give me the definer of that table.</p>
  
  <p>Note that i already have a script that does so for another schema, but i am not sure if the definer for the other schema is the same.</p>
  
  <p>Also, i couldn't find an answer to this over the internet, so i am asking this here.</p>
  
  <p>Thanks.</p>