title: changing hive external table to internal table in the same database also drops the data from the another table
body: <p>I have been trying to drop a hive external table using the statement</p>
  
  <blockquote>
    <p>alter table $tableName set tblproperties('EXTERNAL' = 'FALSE');    </p>
  </blockquote>
  
  <p>after I pass these properties and do a </p>
  
  <blockquote>
    <p>DROP TABLE TABLENAME; </p>
  </blockquote>
  
  <p>this command also drops the data from the other hive tables in that 
  database.</p>
  
  <p>Please can anyone suggest me why is it doing so? also if there is any way 
  where we can only delete one external table which is mentioned without
  loosing the other data.</p>
  
  <pre><code>ALTER TABLE TABLENAME set tblproperties('EXTERNAL' = 'FALSE');
   drop table tablename;
  </code></pre>