int identity not for replication...

Results 1 to 2 of 2

Thread: int identity not for replication...

  1. #1
    Join Date
    Dec 1969

    Default int identity not for replication...

    I have a column in my table named ID which is int identity not for replication with seed =1 starting from 1. I use the ID column as primary key which is used in joins with other tables.<BR>I have a table where records could be added and deleted frequently, I know that the bigger number is too large to get there in my life, but I want to know if there is a way to reasign values to the id column.<BR>I mean update them to be 1,2,3 ... to n where n is the total number of records in the table.<BR>Thanks.<BR><BR>

  2. #2
    Join Date
    Dec 1969
    Indianapolis, IN

    Default You cannot update an identity field <eop>


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts