Identity Column

[Mkanchha]

How to Resize the Identity column values after delete the Row and Insert the New Row. Mohan Balal

[_mubashir]

what do you mean by Resizing Identity column value?

---

Mubashir Software Architect Storan Technologies Inc, USA Every job is a self portrait of the person who did it.

[Jaiprakash M Bankolli]

If you are asking about reseting the table identity once you have deleted all the rows, then use DBCC CHECKIDENT to reseed or reset Identity column.

Regards, Jaiprakash M Bankolli jaiprakash.bankolli@gmail.com http://jaiprakash.blog.com/

[PavanPareta]

It will helpful for you: http://msdn2.microsoft.com/en-us/library/ms176057.aspx[^]

Pavan Pareta