Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Location
    Minneapolis, MN
    Posts
    253

    Unanswered: ALTER'ing Table to Add IDENTITY Column

    Simple question:

    Is it possible to ALTER an existing table to add an IDENTITY column? Whenever I try, I get the "UNEXPECTED TOKEN" error on the key word IDENTITY in the ALTER statement....

    Any insight would be cool. I'd really hate to have to drop nd recreate everything I've already done.

    Thanks!
    Anthony Robinson

    "If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    It is possible if you are on Version 8.2 ...

    Not possible in the earlier versions

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Feb 2002
    Location
    Minneapolis, MN
    Posts
    253
    Nuts!!!! Kinda had a feeling...
    Anthony Robinson

    "If I'm curt with you, it's because time is a factor here. I think fast, I talk fast, and I need you guys to act fast if you want to get out of this. So, pretty please - with sugar on top..."

Posting Permissions

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