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 3:13 pm

    #1386040

    You may use code like this:

    ALTER TABLE [TableName] WITH NOCHECK

    ADD CONSTRAINT [PrimaryKeyName] PRIMARY KEY CLUSTERED ([ExistingColumn])

    WITH (FILLFACTOR = 75, ONLINE = ON, PAD_INDEX = ON);