Click New Query in the context menu. In the Query window, type a statement such as the following: SELECT client_id, first_name, last_name INTO new_table FROM old_table; GO ...

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 ...