Export tablestructure in SQL statement

T

TNL

Hi,
can access export the tablestructure, relations in SQL
script, that we can use it to restore the tablestructure,
as:
CREATE TABLE...

Is there a tool for this purpose?

Thanks
TNL
 
J

Joe Fallon

You are asking if Access can write a script to re-create the database.
The answer is no - it is not built in.

But you can write your own code to generate this info.
Many MVPs have done it - but I am not one of them so I can't post it! Sorry.

SQL Server has built in scripting for all objects.
 

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

Top