How to Drop Identity Property of a Column in SQL Server Table - SQL Server Tutorial Part 44

SQL Server / TSQL Tutorial Scenario: How to Drop Identity Property of a Column in SQL Server Table In this video we will learn how to drop identity property of a column in SQL Server Table. We will follow below steps. Add a new column with TestID to existing Table Update the records from Id ( Identity enable Column) to TestID (Newly Added) Column. Drop the Id ( Identity Enable Column) from Table Rename the Newly Added Column ( TestID) to Id. Link to scripts used in the video http://www.techbrothersit.com/2015/02/how-to-drop-identity-property-of-column.html Check out our website for Different SQL Server, MSBI tutorials and interview questions such as SQL Server Reporting Services(SSRS) Tutorial SQL Server Integration Services(SSIS) Tutorial SQL Server DBA Tutorial SQL Server / TSQL Tutorial ( Beginner to Advance) http://www.techbrothersit.com/