D
David Husnian
I have a database designed with 27 tables and a number of
relationships. In some of the tables I have an "int
identity" column defined but when I generate the DDL
script a few of the tables (4 if I recall) don't generate
the identity. That is, they just say "int not null"
instead of "int identity not null".
At first I thought I had forgotten to make them identity
columns but when I go back into the designer and look at
the properties it does say they are identity columns. But
whenever I generate the DDL it doesn't generate it
correctly.
I tried to report this to Microsoft but first the online
reportiing wizard didn't like my EA product ID (it said it
was invalid) then when I used the ID from a copy of Pro it
took the number but said they wouldn't support me because
it is an MSDN subscription (although it is a Universal one
so I thought I'd get some support!)
Any ideas on why this code is not generating correctly is
or what I can do get it to do so? It makes me not be able
to trust any of the generated DDL code.
Thanks,
David
relationships. In some of the tables I have an "int
identity" column defined but when I generate the DDL
script a few of the tables (4 if I recall) don't generate
the identity. That is, they just say "int not null"
instead of "int identity not null".
At first I thought I had forgotten to make them identity
columns but when I go back into the designer and look at
the properties it does say they are identity columns. But
whenever I generate the DDL it doesn't generate it
correctly.
I tried to report this to Microsoft but first the online
reportiing wizard didn't like my EA product ID (it said it
was invalid) then when I used the ID from a copy of Pro it
took the number but said they wouldn't support me because
it is an MSDN subscription (although it is a Universal one
so I thought I'd get some support!)
Any ideas on why this code is not generating correctly is
or what I can do get it to do so? It makes me not be able
to trust any of the generated DDL code.
Thanks,
David