How to retrieve DDL script for table in mdb file

[Dhananjay]

Hi All,

I am trying to retrieve DDL script for mdb tables.
script like..

"CREATE TABLE TB_NAME ([FIELD1] TEXT(30), [FILED2] MEMO)"

Currently i am using DAO COM Library to extract other table informations.
But I didnt get any method to get DDL Script for table.

Is there any other library to retrieve the script?

Thanks for any HELP..

Dhananjay

 

[RoyVidar]

Hi All,

I am trying to retrieve DDL script for mdb tables.
script like..

"CREATE TABLE TB_NAME ([FIELD1] TEXT(30), [FILED2] MEMO)"

Currently i am using DAO COM Library to extract other table
informations. But I didnt get any method to get DDL Script for
table.

Is there any other library to retrieve the script?

Thanks for any HELP..

Dhananjay

I'm sorry, I don't think you will find such scripts anywhere. If
you really need them, I think you'll need to extract the information
through the methods you're using (or the ADO OpenSchema, or ADOX...),
and build the DDL yourself.

Perhaps if you tell us what you wisht to achieve, someone can assist
in finding relevant methods, workarounds etc

 

[Douglas J. Steele]

Unlike SQL Server, Access doesn't create DDL script.

There are 3rd party products that can do this, but I'm afraid I don't have
the references to any of them handy.