Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2007
    Posts
    2

    Question Unanswered: Setting counters after tables are built

    Hi,

    Is there a way to set the count for a auto incrementing field after the the table has been built? (or do I have to set the counter start values in the build code?)

    I'm moving a database to a different environment and after building and importing the data I realized that I forgot to set the counters above existing row counts.

    This is on DB2 UDB V8 on Windows.

    Any help would be appreciated thanks

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    ALTER TABLE Mytable ALTER COLUMN ID_Column restart with 12345

    Andy

  3. #3
    Join Date
    Jan 2007
    Posts
    2

    Thanks

    Thanks

    Bob.

Posting Permissions

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