change column auto increment in sql

Question

I have created table

create table student(rollno int,studname varchar(30),mark1 int,mark2 int,total as (mark1+mark2))

I have inserted 5 values  with different rollno.Now i want to change  that rollno as auto increment.

question:

1)I want sql query to change the rollno as auto increment.

2)previous rollno values also need to change.

by

 Mukilan

Answer 1

Hello Mukilan,

Similiar to my answer to your other post http://social.msdn.microsoft.com/Forums/de-DE/sqltools/thread/ae603ea9-a766-4a0d-8917-039eb6c2d285

You have to re-create the table.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

I need query to alter column as auto increment column  in sql

Answer 3

Hi,

Create a new column with identity and drop the existing column.

---

ESHANI. Please click "Mark As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

Answer 4

I need query to alter column as auto increment column  in sql

See ALTER TABLE, it's not possible to change a column to IDENTITY afterwards, you eigher have to add a new column with IDENTITY property or you have to recreate the table.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing