Results 1 to 2 of 2

Thread: auto-increment

  1. #1
    Join Date
    Mar 2004

    Unanswered: auto-increment

    I am just starting to use Sybase and I cannot seem to figure out how to have a field in a table auto-increment itself (i.e. for an id). Is there an auto-increment feature built into Sybase, or will I have to write a SP to do it?

    Thanks in advance,

  2. #2
    Join Date
    Jan 2004
    Provided Answers: 4
    With the ' identity' type, you have auto-numbering

    create table dbo.test(
    id numeric(9, 0) identity ,
    column2 int null,
    I'm not crazy, I'm an aeroplane!

Posting Permissions

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