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.