Results 1 to 3 of 3
  1. #1
    Join Date
    May 2012
    Posts
    2

    Unanswered: Identity column in sybase

    Hi,

    While creating a table in sybase i want the identity column to start from a particular value and increment by a predefined value.
    This is solely for testing purpose.Any help would be highly appreciated..

  2. #2
    Join Date
    May 2012
    Posts
    4
    Hi ,

    I'm beginner in sybase .You can add a identity column in your current table by using alter table command and setting the identity_insert <table> off.Then by default ,column values will be incremented by one rite...
    Correct me if Im wrong.

    Thanks

  3. #3
    Join Date
    Jun 2011
    Posts
    28
    Hi

    Yo need to use
    Code:
    sp_chgattribute TABLE_NAME, 'identity_burn_max', 0, '0'
    instead 0 you use the value that you want.

    Regards

Posting Permissions

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