Home Forums Article Discussions Article Discussions by Author Discuss content posted by Thomas Pieries Changing a Non-IDENTITY column to IDENTITY and vice versa RE: Changing a Non-IDENTITY column to IDENTITY and vice versa

  • February 25, 2008 at 5:05 pm

    #781827

    Daniel R. Kusnadi (2/21/2008)

    Hi Thomas,

    isn't just opening 'design table' from SQL management and edit the column to have identity or not, works as well?

    or it might be just me missing the point.

    Cheers,

    DK

    I have to agree with Daniel. The article is well written and well thought out, but in most case where there are no complicating factors it seems easiest just to use design table. Now, as can be seen by generating the change script, what this does in effect is very similar to method 2 listed, but in most cases it makes sense to let the gui handle that.

    ---
    Timothy A Wiseman
    SQL Blog: http://timothyawiseman.wordpress.com/