Решение:

Alter Table bsh_pageTypes
Add Id_new Int Identity(1, 1) primary key
Go

Alter Table bsh_pageTypes Drop Column id
Go

Exec sp_rename 'bsh_pageTypes.Id_new', 'st_id', 'Column'