A SQL Server database table has had records added to it by me. The auto-increment identity seed was set to "Yes" and the table had been defined with a primary key. This is done mostly because each table in SQL Azure needs to have an identity and primary key defined.
The identification seed for those tables will be disturbed, as will the index column (which is automatically generated with an increment of 1), as I have to delete certain data from the table.
How can I reset the identity column after I deleted the records so that the column has a sequence in ascending numerical order?
The identity column is not used as a foreign key anywhere in the database.