title: ALTER VIEW to add select statement to UNION
body: <p>Right now I have a view that looks like this:</p>
  <pre><code>CREATE VIEW fruits AS
  SELECT A, B, C
    FROM apple
  UNION ALL
  SELECT A, B, C
    FROM banana
  </code></pre>
  <p>When I add the <code>cherry</code> table to my project I would like to do something like this:</p>
  <pre><code>ALTER VIEW fruits ADD
  SELECT A, B, C
    FROM cherry
  </code></pre>
  <p>Obviously that does not work.</p>
  <p>What kind of creative solutions can SO come up with to help me manage this view?</p>
  <p>The context of this is that this database supports an application that uses plug in architecture so as plugins are activated the view needs to change.</p>
  <p>[EDIT] Please do not get distracted with the simplicity of the tables.  The real tables are more complex and not subject to being merged.   The new tables are part of the installed plugin and would not be in the initial install of the system.  If we can't find a database way to change the view then we will make this a DBA procedure to follow when a new plugin is installed.</p>