It is also useful if you are running SQL statements from an SQL application ... The specified columns are dropped when the table is created. Indexes are not copied to the new table. Both of these ...