title: How to fix a broken SQL view
body: <p>I am using the open source CMS pimcore (http://www.pimcore.org), which runs on a MySQL backend.</p>
  
  <p>It uses fairly complicated views to represent objects and one of them has become broken at some stage when a column in another table being referenced by the view was renamed. Whenever I try to interact with the table via SQL commands I receive the error: </p>
  
  <blockquote>
    <p>View 'barriste_website.object_6' references invalid table(s) or
    column(s) or function(s) or definer/invoker of view lack rights to use
    them</p>
  </blockquote>
  
  <p>I would like to simply update the view to reference the renamed columns, but I need to know the current structure of the view before I start poking around - how exactly do I retrieve the structure of the view once it is broken? I've tried</p>
  
  <pre><code>SHOW CREATE VIEW object_6
  </code></pre>
  
  <p>but I receive the same error.</p>
  
  <p>Thanks for your help in advance!</p>