magritton
4/8/2015 - 12:52 PM

SQL code for changing a column to an identity column that is a primary key. You have to drop the key, drop the column, add the column back i

SQL code for changing a column to an identity column that is a primary key. You have to drop the key, drop the column, add the column back in and then set the primary key

SQL Change Column.sql
content_copyfile_download
ALTER TABLE CEFP.CEFPInspectionLeakage DROP CONSTRAINT pkCEFPInspectionLeakageID
ALTER TABLE CEFP.CEFPInspectionLeakage DROP COLUMN InspectionLeakageID
ALTER TABLE CEFP.CEFPInspectionLeakage add InspectionLeakageID int identity(1,1)
ALTER TABLE CEFP.CEFPInspectionLeakage ADD CONSTRAINT pkCEFPInspectionLeakageID PRIMARY KEY(InspectionLeakageID)