I have inherited an old data model from Case Studio (Microsoft SQL Server 2005) which when loaded into Toad Data Modeler it isn’t properly generating the attributes.
The current attributes are defined as Domain N12 (which is a simple Numeric(12,0). This itself is fine, but it is missing the fact all these attributes should also be Identity columns.
If I manually change the Primary Key attribute from N12 to Numeric(12,0), the Identity property fills in.
I have over 500 entities and manually doing this is very painful.
Is there a macro or something I’m missing which could help me reset all the primary key attributes to use the NUMERIC(12,0) datatype and have an Identity flag set (Seed = 1, Increment = 1)?