Remove IDENTITY property from PRIMARY KEY column

• binutb

  SSCommitted

  Points: 1741

  More actions

  December 6, 2016 at 11:15 pm

  #401169

  I have table with IDENTITY property in PRIMARY KEY column.

  How to remove existing IDENTITY property form the PRIMARY KEY column

• MadAdmin

  SSChampion

  Points: 11261

  More actions

  December 7, 2016 at 2:04 am

  #1916425

  Add column with temp column name as nullible.

  Copy values from ID to temp column.

  Drop PK and ID column

  Rename temp column to ID.

  Change column to not nullible.

  Create PK on New ID column.

  Catch-all queries done right [/url]
  Gail Shaw's Performance Blog[/url]