Posted by Johnny Ruin on 09/09/05 18:50

Hi,

I simply want to create a duplicate of an existing table with a
different name. I've tried the "select * into newtable from
orgtable", which works great, except that it doesn't mark the primary
key field from orgtable in the newtable. I tried creating the
newtable prior to using this select, but then sql server cries about
the table already existing. I tried creating the index after the
select "CREATE UNIQUE INDEX FieldAIndex ON newtable (FieldA)" - that
didn't give a error, but also failed to mark the field as primary.
Suggestions?

[Back to original message]