Results 1 to 3 of 3

Thread: identity fields

  1. #1
    Join Date
    Dec 2003
    Posts
    44

    Unanswered: identity fields

    how do I start an auto increment field at a certain number? other than 1

  2. #2
    Join Date
    Oct 2003
    Location
    Newcastle, Australia
    Posts
    51
    CREATE TABLE test (
    test_id int NOT NULL IDENTITY (100, 1)
    )

    will create a table where the test_id column starts at 100

  3. #3
    Join Date
    Mar 2004
    Location
    Ohio
    Posts
    16

    Assuming Microsoft SQL

    Open desired table in design mode
    Set the Identity property to "Yes" for the desired field
    Set Identity Seed property to the desired value

    You can even set the increment value here.

    ???

Posting Permissions

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