Information générale
Forum:
Microsoft SQL Server
Titre:
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).
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement