Home Forums SQL Server 2005 Development Adding Primary key column to existing table RE: Adding Primary key column to existing table

  • September 23, 2011 at 2:40 pm

    #1386031

    Using SQL Server 10.0.2531 Management Studio, I was able to skip the updating values part.

    So,

    1. Design table, Add

    .[Id] column as Identity seed 1 increment 1, save.

    2. Right click [Id] column, set as primary key, save. Done.

    SQL server added the incrementing values automatically! Awesome product.


    {Francisco}