SQL: Add an Identity Column to an Existing Database Table

The following will add a new identity column "Id" to an existing table "Users". It will be a non-nullable, identity column, with the unique values filled in.

copy
ALTER TABLE Users
ADD Id INT IDENTITY(1,1)