General information
Forum:
Microsoft SQL Server
Title:
Resetting the value of an Identity column
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).
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only