How to retrieve DDL script for table in mdb file

  • Thread starter Thread starter Dhananjay
  • Start date Start date
D

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
 
Dhananjay said:
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
Click to expand...

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
 
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.
 
Back
Top