how to make existing column auto increment in sql server code example
Example 1: sql query to make a existing column auto increment
Alter table table_name modify column_name datatype(length) AUTO_INCREMENT PRIMARY KEY
Example 2: how to alter auto increment in sql
INSERT INTO Persons (Personid,FirstName,LastName)
VALUES (seq_person.nextval,'Lars','Monsen');