• Question stated "Now I need a copy of this table with an identity column for some temporary work." This is the phrase that pointed me to select "Use an identity function with a SELECT INTO" as the answer. No need for the constraints etc from the source table, just a quick and dirty copy for temporary work.

    The part of the question that Steve updated didn't even play a part in my decision making process.