If you drop a table with indexed columns, all the indexes are automatically dropped. If you drop a composite index, the index is dropped for all the columns that are named in that index. You cannot ...

Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql. In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored procedure.<BR ...

Replace "new_table" with the name of the table to create, and replace "old_table" with the name of the table to select from. The INTO clause behaves the same as CREATE TABLE in other SQL environments.