Post reply

Identity in DDL

  • January 23, 2002 at 2:53 pm

    #78198

    I am creating a table with the primary key being an identity column. This is the snippet of my DDL and I get an error saying

    seq_nbr must include a datatpye. whats up with that? Isnt identiy int a valid datatype?

    CREATE TABLE doc_trans

    (seq_nbr identity int NOT NULL,

    doc_id varchar(22) NULL,

    release_nbr decimal(10,0) NULL,

  • January 23, 2002 at 3:03 pm

    #422558

    It is int identity and not identity int. I dont understand why the datatype is called identity int when you got to define as int identity. Oh well..

  • January 23, 2002 at 3:16 pm

    #422561

    The datatype is int. A property of this column is identity.

    Steve Jones

    steve@dkranch.net

  • January 23, 2002 at 5:23 pm

    #422574

    Thanks Steve!! I was a little frustrated basically venting out..

  • January 24, 2002 at 9:49 am

    #422609

    np. just trying to clarify. Didn't want to pick on you.

    Steve Jones

    steve@dkranch.net

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply