Will Access Expose DDL?

[Smartin]

Is there a way to coerce Access to expose the DDL for all tables and
relationships in an Access database?

 

[John Vinson]

Is there a way to coerce Access to expose the DDL for all tables and
relationships in an Access database?

No, not within Access itself. Unlike in SQL, the information is not
stored in that manner within the database.

Tools... Analyze... Documentor is about as close as you can get.

Someone has probably written a (VERY nontrivial) VBA routine to crawl
through the DAO or ADO object model and actually construct the SQL
strings involved, but I haven't seen such code.

John W. Vinson[MVP]

 

[Guest]

It's a bit easier now than it used to be, but the problem
is that it is still not possible to re-create constraints and
default values using DDL. Let alone lookup fields and
SubDataSheet properties.

(david)

 

[John Vinson]

It's a bit easier now than it used to be, but the problem
is that it is still not possible to re-create constraints and
default values using DDL.
True...

Let alone lookup fields and
SubDataSheet properties.

not that anyone who prefers DDL would ever WANT to! <g>

John W. Vinson[MVP]