MSSQL IDENTITY entfernen

[LeKuchen]

Tag,

naja, ganz so einfach war es nun doch nicht, aber so geht es:

1> ALTER TABLE [table] ADD [pid] [int]
2> ALTER TABLE [table] ADD [tmpid] [int] IDENTITY (1, 1) NOT NULL
3> UPDATE [table] set [pid] = [tmpid]
4> DELETE FROM [table] WHERE [pid] = NULL
5> ALTER TABLE [table] ALTER COLUMN [pid] [int] NOT NULL
6> ALTER TABLE [table] WITH NOCHECK ADD CONSTRAINT [PK_table] PRIMARY KEY CLUSTERED ( [pid] ) ON [PRIMARY]
7> ALTER TABLE [table] DROP COLUMN [tmpid]

Gruß
LeKuchen