how can i refresh Unique Index when i want to reinsert data into table? RRS feed

  • Question

  • Hi.

    i have created a Table in Sqlserver 2008r2 as

    Table=Country(CountryId (Int,not null,Unique Index) ,CountryName

    I had inserted data into this table , but i decided to
    delete them , now when i want to reinsert data into the table , it has memorized
    it's previous Indexes and
    CountryId starts from (for example 14), while i
    want to start it from number 1.
    what shall i do?
    Wednesday, August 1, 2012 4:45 AM


  • Check DBCC CHECKINDENT command in BOL.

    For every expert, there is an equal and opposite expert. - Becker's Law

    My blog

    • Marked as answer by great ehsan Wednesday, August 1, 2012 5:04 AM
    Wednesday, August 1, 2012 4:59 AM