Copy table with Indexes

Friday, 15 May 2009

Hey Guys,

We create a copy of table using SELECT INTO .. query, but we know that it doesn't carry the indexes to the new table.

Suggest the different ways for carrying the Indexes to the new table that we are copying...

Thanks in advance