• I don't think Select Into configures indexes and keys.

    You may want to script the table first with all keys and indexes but WITHOUT Drop Table option so you would not accedentally delete your original table, in the script replace a table name with a new name, run the script to create a new table. The use Jim P.'s second  syntax to get data in the case the new table already exists.

    Yelena

    Regards,Yelena Varsha