Tibor Karaszi, SQL Server MVP
FAQ from Neil at: http://www.sqlserverfaq.com
Please reply to the newsgroup only, not by email.
Andrew J. Kelly
Quote:> Hi all,
> I have 4 tables which i need to populate before populating a 5th table.
> these 4 tables have identity on their primary keys. I need to delete all
> rows from all these 4 tables each time before reinserting them.But due to
> this the identity keeps on incrementing.Is there a way to reset the
> seed?? I cannot use the TRUNCATE TABLE method as i have foreign key
> relationships between these tables.
Can anyone help I need to reset some auto-generated
identity columns on a table to '1', how?