SQL server 7.0 problem

Results 1 to 2 of 2

Thread: SQL server 7.0 problem

  1. #1
    Join Date
    Dec 1969

    Default SQL server 7.0 problem

    i have this table called personal<BR>to make a unique primary key i have made the<BR>P_contact_id a primary key where i choose the identity seed option for this coloumn and set the increament to 1<BR>Question:<BR>when i delete any record from this table the indexing does not change that means the next number does not take the number from the previous record.<BR>will there are about five tables that has been created in this way .do you think it is a good practice to do so.<BR>please tell me the pitfalls of using this kind of indexing....<BR>thank u in advance

  2. #2
    Join Date
    Dec 1969

    Default Good!

    If it did reassign your primary keys to other records, it would screw up any relationships with records in other tables.<BR><BR>It is most definitely not supposed to reassign unique key identity values.<BR><BR>Works as designed...And, in 99.9% of cases you should use this method in SQL Server to ensure your primary keys.

Posting Permissions

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