SQL server IDENTITY column

[Ed Vowles]

I would like to use enterprise architect to set a column on a table as an identity column (SQL server 2005). When I generate the table DDL I would like output to include the IDENTITY keyword. Something like:

Code: [Select]

CREATE TABLE Customer (
      ID int IDENTITY NOT NULL,
      Name nvarchar(50) NOT NULL,
)
;
Is this possible?!

Thanks
Ed

[Ed Vowles]

I think I may have answered my own question:

Element menu -> attributes -> select column -> column properties -> auto number

Is this documented in any of the online resources? I'd like to read up on how enterprise architect maps tables in its data model to SQL server scripts.

Ed

[«Midnight»]

This used to be documented, and I've not heard of changes.

What documentation there is on how EA maps diagrams to SQL is somewhat scattered. AFAIK there is no combined section on what goes where when DDL is generated. Unfortunately the DDL generation process is a black box, there is nothing like the code generation framework that we can hook into.

Make feature requests, and perhaps these will (finally, someday) rise high enough on the priority list that Sparx will (can) take action.

[Ed Vowles]

Thanks Midnight