SELECT * INTO new_table_name [IN externaldatabase] FROM old_table_name
or
SELECT column_name(s) INTO new_table_name [IN externaldatabase] FROM old_table_name