Is there a way to describe an attribute in the logical model that would result in it being tagged as an IDENTITY column in the physical model?
We’re in the early stages of building a DB from scratch. Because of this, we keep returning to the logical model to add new tables and relationships, then regenerate the physcial design before uploading the DDL to the server. Two things that are annoying my about this are
The DDL doesn’t generate DROP TABLE statements so I mush manually drop the tables (or recreate the DB) every iteration and
I must re-visit each SAPK and re-tag it as an IDENTITY column (SQL Server) before generating the DDL.
Please open the DDL Script Generation dialog | What to Generate tab | at the Entities item click the Extended Value column | now you can select from the combo-box Create, Drop or Drop and Create.