Dbcc checkident can reseed (reset) the identity value of the table. for example, yourtable has 25 rows with 25 as last identity. if we want next record to have identity as 35 we need to run following t sql script in query analyzer. if table has to start with an identity of 1 with the next insert. For instance, if you copy all the table's records to an archive table and then delete all the records in the source table, you might want to reseed the source table's identity column, so you can. I imagine you are just looking for simple syntax in order to reseed the identity column of a table you just deleted from. here is the quick version:.
Script to reseed tables in sql i have a series of tables that basically need to use two series of seeded values in the identity column the master entries in the tables that we create will start off with identities like below.... Dbcc reseed table identity value an identity column in a table is used to auto generate new values based on current seed and increment value. seed is the first value or the value to start with whereas increment is the value added to previous value to get the new identity value.. Hi, i have a indexing problem. i have a sequence that needs to has a index number. i want to use a table data type and have a working sample but i cannot reseed the table when needed..
