title: SQL Server: copy all tables into new tables
body: <p>I am having a problem. </p>
  
  <p>I am trying to create an easy way to make a copy of <code>Table1</code> to <code>Table2</code>. Now I know the <code>Select Into</code>, but in this there is say table 1 through table 100 and I am trying to create a duplicate of all of them. SSIS or SQL is OK. </p>
  
  <p>The reason for the copy is say I have 2 tables within a classes database.  Alegra 101 and 102, I am trying to create algebra 103   this will work for all of the tables, like Health 101 and 102, assume there are around 100 different classes with a 101 level and a 102 level that need a 103. </p>