title: Create temp table in SQLite if another table exists
body: <p>I need to create a temp table (which is a copy of Employees table) in a SQLite database, provided the table by the name of 'Employees' exists. There are only 2 columns in Employees table - EmployeeId (integer) and EmployeeName (varchar(100)).</p>
  
  <p><strong>Is there any way to implement the above using SQLite SQL?</strong></p>
  
  <p>Pseudo-code for intended SQL, which does not work in SQlite is as below. I hope there was something as powerful as the pseudo-code below in SQLite.</p>
  
  <pre><code>--if Employees table exists then create a temp table and populate it with all 
  --rows from Employees table
  CREATE TEMP TABLE tempEmployees if exists Employees as select *  from Employees;
  </code></pre>