Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    1

    Unanswered: Use auto_increment in sybase

    Hi,

    I have experience with MySQL and I am trying to create a table in sybase and make the Primary Key auto_increment. The primary key is of type INTEGER.

    Thanks!

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002

  3. #3
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524

    Exclamation

    1) identity option only runs using numeric(n,0) datatype, not INT.
    2) Create a nonclustered primay key when you're using identity, else you will create a bottleneck in the last page of your table

Posting Permissions

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