title: Create View that references view not created yet
body: <p>I have a schema extraction tool for SQL &amp; Oracle which then tries to create a new database from the schema of another one.</p>
  
  <p>I have encountered a problem with SQL at the moment (most likely exists in Oracle) that when it tries to do something like</p>
  
  <pre><code>CREATE VIEW TestView
  SELECT * FROM AnotherViewNotCreated
  </code></pre>
  
  <p>it errors.</p>
  
  <p>I thought using the <code>EXEC</code> command in SQL would work but it also complains that the view does not exist.</p>
  
  <p>Is there a way I can create the views even if they reference other views that do not exist yet?</p>
  
  <p><strong>UPDATE:</strong> I've noticed if you Generate Scripts from SQL it outputs the order of view creation in an order that seems to suggest it knows which ones should be created first to prevent reference issues.  Wonder how it knows?</p>