Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Location
    Hartford, CT
    Posts
    106

    Unanswered: DDL PK autonumber

    Hi,

    This is a create statement that I am trying to execute:

    CREATE TABLE zModules
    ([Module_ID] autonumber PRIMARY KEY,
    [Module_Name] text
    );

    I am getting a syntax error on the "autonumber" data type. I don't get this error if I changed autonumber to integer.

    Please advise; How can I make the PK an autonumber?

    Thanks
    Last edited by mkasem; 02-19-03 at 10:58.
    Mo

  2. #2
    Join Date
    Aug 2002
    Location
    Northampton, England
    Posts
    266
    Try this

    CREATE TABLE zModules(Modules_ID AutoIncrement CONSTRAINT C1 Primary Key,Module_Name Text(255))

    David

  3. #3
    Join Date
    Oct 2002
    Location
    Hartford, CT
    Posts
    106
    Thanks a lot, that worked great.
    Mo

Posting Permissions

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