Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: Supe on March 28, 2017, 01:28:08 pm

Title: int, identity column
Post by: Supe 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])
);

Title: Re: int, identity column
Post by: hd on March 28, 2017, 01:35:57 pm

Database Builder - Column Properties...
http://www.sparxsystems.com/enterprise_architect_user_guide/13.0/model_domains/createcolumns.html (http://www.sparxsystems.com/enterprise_architect_user_guide/13.0/model_domains/createcolumns.html)

Title: Re: int, identity column
Post by: Supe 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?

Title: Re: int, identity column
Post by: hd 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.