Home Forums SQL Server 2005 Administering Adding identity property on primary key column RE: Adding identity property on primary key column

  • June 23, 2009 at 8:08 am

    #1013960

    you should be able to create a new column and make it identity and primary key:

    Question: will this default your existing primary key column and uniqueness..

    ALTER TABLE ABC

    ADD NEWCOL int IDENTITY(1,1) PRIMARY KEY

    Maninder
    www.dbanation.com