title: Alternative to Select Into
body: <p>I'm using SQLite in a Delphi XE7 application and need to make a copy of any number of a possible 106 columns from one table into another table that needs to be created dynaically using the same types. If "Select Into" worked with SQLite, the SQL would look something like:</p>
  
  <pre>
    SELECT 
      "RecNum", 
      "TK Number", 
      "Type", 
      "Disc.",
      "Project Description",
      "Date Added"
    INTO
      "CurrentLimited"
    FROM
      "Current"
  </pre>
  
  <p>If those were the selected fields. The target and source tablenames will be static. The query is attached to a TQuery, so if there is a way to save the results of the TQuery as a table in the same database (I don't think SaveToFile offers that) then that would work too.</p>