How to set Identity in sql

Accepted answer

then u have to first drop sno column and then add new column id with identity property
like
Alter Table student Drop column [sno]
Alter Table student Add id int identity(1,1)

Ankit Nandekar15y ago

thank you so much prabhakar.

Prabhakar Parihar15y ago

thanks for replying . . ur code now working for me . . and i marked as a correct answer . .

Prabhakar Parihar15y ago

in ur reply . . where u set Identity on id column . .

Prabhakar Parihar15y ago

yeh i want to remove sno column identity and then set column id with identity

Ankit Nandekar15y ago

you want to remove sno column identity property and want new column id with identity?
You can not remove Identity propery of a column with out droping it.

Prabhakar Parihar15y ago

hi ankit, , thanks for replying. . i want to remove column sno identity then set column id identity . . by query how'z the way solve this problem

Ankit Nandekar15y ago

try this
CREATE TABLE student (
[sno] [int] IDENTITY(1,1) NOT NULL,
)