Hi Charles,
TRUNCATE TABLE will reset Identity column. If for some reason you cannot use it, take a look at DBCC CHECKIDENT in BOL.
>I'm dealing with updating Zip Code and Phone (area code and exchange information) in SQL Server. The process is as follows:
>
>Delete all records from the existing Zip/Phone table
>Reimport all of the records from the update disks.
>
>The iID column is added to the structure of the data we pay for, for update purposes only (remote views in VFP are being used) ... they are not used as foreign keys in any other table. I'd like to reset the value of the Identity column to 1 each time I do this.
>
>Does anyone know the SQL syntax to do this?
>
>Thanks,
>
>CTBlankenship
>(New to SQL Server but learning).
--sb--