Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005
    Posts
    42

    Angry Unanswered: Want to modify exeist field to Identity

    This commant does not work

    alter table emp1 modify empid numeric(5,0) identity not null

    Regards
    Bala

  2. #2
    Join Date
    Mar 2006
    Posts
    25

    Unhappy

    hi

    you cannot modify an existing column with an identity column.

    Quote Originally Posted by bala_m
    This commant does not work

    alter table emp1 modify empid numeric(5,0) identity not null

    Regards
    Bala

Posting Permissions

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