Author Topic: int, identity column  (Read 4638 times)

Supe

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
int, identity column
« on: March 28, 2017, 01:28:08 pm »
Hi all,

Does anyone know how to create a int, identity column?

e.g.
create table [dbo].[ServiceGroupLookup] (
    [ID] [int] not null identity,
    [DelayBetweenOperationsInMilliseconds] [int] not null,
    [Name] [varchar](50) not null,
    [LastModifiedByUsername] [varchar](100) not null,
    [LastModifiedDateTime] [datetime2](7) not null,
    [RecordRowVersion] [rowversion] not null,
    primary key ([ID])
);

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: int, identity column
« Reply #1 on: March 28, 2017, 01:35:57 pm »

Supe

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: int, identity column
« Reply #2 on: March 28, 2017, 01:58:13 pm »
Adding "Identity" to the Initial attributes generates the table in SQL with the word "default" which throws out an error. Can this be removed?

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: int, identity column
« Reply #3 on: March 29, 2017, 07:43:53 am »
Select your table in the Database Builder, select your identity column, set AutoNum to true in column properties list at lower left.