how to get create SQL from existing tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

there are many existing tables, and i want to get the create SQL for them,
how to do that ?
 
there are many existing tables, and i want to get the create SQL for them,
how to do that ?
Click to expand...

There's no automated way to do so in Access. A couple of people have
written VBA code to use the DAO Fields collection to construct DDL SQL
statements, but I haven't worked with them.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Print Files from Query Results 0
SQL script to solve problem 1
What are the steps to fix damaged MDF files in SQL Server? 0
Why won't Access assign a Primary Key ID to my linked SQL Table? 2
I need help on SQL 0
Access Access 2010 import/append data into table w/o overwriting existing records 0
Call stored procedure in SSMS from Access 2016 doesn't work. 0
replacing a link to a SQL Server table with VBA 1

Back
Top