Add auto increment to newly added column which is null with

mohammed shamsheer

13y1.8k

I have a table with 11 rows variable now i am need in id column and set as primary key and i want to number or auto increment the id column for 11 rows

eg :
id name address
null a b
null c d
.
.
11 records

i want ot output like that
id name address
1 a b
2 c d
.
.
.
11 z f

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
Accepted answer
Hi,

Create a new column with identity & drop the existing column

Alter Table Table1
Add Id_new Int Identity(1, 1)
Go

Alter Table Table1 Drop Column ID
Go
Exec sp_rename 'Table1.Id_new', 'ID', 'Column'
GO

Regards,
Iftikar

Sanjeeb Lenka13y ago

try this

Alter table Example add NewColumn int identity(1,1)

Ravi Shekhar13y ago
You can make your first column as int identity(1,1)

Means your first column first row value is 1 after that it will increment by 1.

Regards,

Ravi