I have insert records in the SQL Server database table. The table had primary key defined and an auto increment identity seed is set to YES. This is done primarly because in SQL Azure, each table has to have an primary key and Identity Defined.
But since I now to have delete some records from the table, the identity seed for those table will be disturbed and hence the Index column (which is autogenerated with an increment of 1) will get disturbed.
Therefore, kindly let me know how can reset the Identity column after I delete the records so that the column has sequence in ascending numerical order.
P.S. : The Identity column is not used as a FK anywhere in database.