IF OBJECT_ID ('Tax', 'U') IS NOT NULL DROP TABLE Tax; GO CREATE TABLE Tax ( TaxId int IDENTITY(1,1), );
Alter Table Tax Add TaxId_new Int Identity(1, 1) Go Alter Table Tax Drop Column TaxID Go Exec sp_rename 'Tax.TaxId_new', 'TaxID', 'Column'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)