Export tablestructure in SQL statement

  • Thread starter Thread starter TNL
  • Start date Start date
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
 
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.
 
Back
Top