title: Temporary tables in hana
body: <p>it it possible to write script in hana that crate temporary table that is based </p>
  
  <p>on existing table (with no need to define columns and columns types hard coded ):</p>
  
  <pre><code> create local temporary table #mytemp (id integer, name varchar(20));
  </code></pre>
  
  <p>create temporary table with the same columns definitions and contain the 
  same data ? if so ..i ill be glad to get some examples</p>
  
  <p>i am searching the internet for 2 days and i couldn't find anything useful </p>
  
  <p>thanks</p>