Missing Default in DDL for MSAccess

[RobVen]

Hello,

after creating DDL for a MSAccess DataModel defaults are missing in the Create Table statements, although they are defined in the model.

For example:
Having a DataModel with the table "Keyword" with the column "LanguageCode" of data type "Integer" with option "Initial" set to "15".

Generating DDL for the package resulting in the following DDL:

Code: [Select]

CREATE TABLE Keyword(
 ...
 LanguageCode Integer,
 ...
)
;

Instead it should be:

Code: [Select]

CREATE TABLE Keyword(
 ...
 LanguageCode Integer Default 15,
 ...
)
;

Exploring the newsgroups I found that the "Default"-Syntax is only supported by using ADO and not Access queries.
So in one situation the DDL should include "Default" (when using ADO for DDL scripts) in other situations the resulting DDL should not include it (when using Access queries for DDL scripts).

I personally use ADO so I'm in need of the "Default" statement part.

Do you have any solution to my problem?

Thanks in advance,
Robert

[uschumacher]

Hi all,

i've got the same problem, very annoying  

With SQl Server as the target it works...

Then i found this in the readme.txt:
Generate DDL - prevented generation of column default values for MS Access CREATE TABLE statements.

Is there any workaround or is it possible to edit the DDL Generation scripts?

Thanks in advance
Ulrich Schumacher

[thomaskilian]

There is a similar thread that has been discussed recently (too lazy to search for it: use "DDL" "CODE"). You likely have to write a code generation that fits your needs. There might be another solution, though.