SQL SERVER – How to an Add Identity Column to Table in SQL Server
- by Pinal Dave
Here is the question I received on SQLAuthority Fan Page.
“How do I add an identity column to Table in SQL Server? “
Sometime the questions are very very simple but the answer is not easy to find.
Scenario 1:
If you are table does not have identity column, you can simply add the identity column by executing following script:
ALTER TABLE MyTable
…