title: How to handle DROP TABLE if there is a view on a table?
body: <p><code>View</code> can be dropped using the <code>DROP VIEW</code> command. Is there a solution for handling <code>DROP TABLE</code> if there is a view on a table?</p>
  
  <p>I tried like </p>
  
  <pre><code>DROP TABLE ORDER_TBL CASCADE;
  </code></pre>
  
  <p>Is there another way in a modern <a href="http://en.wikipedia.org/wiki/Database#Terminology_and_overview" rel="nofollow">DBMS</a>? </p>