export table structure in SQL

[Martin]

Hi,

is there a tool to export access 2000 table structure in SQL command?
Is there such a thing in access?

Thanks
Nhan

 

[Van T. Dinh]

Not AFAIK.

There may be 3rd-party utility that can partially do this but I don't know
any.

The question is why you need to export the Table Structure in *SQL*?

Each database engine tends to have its own flavour of SQL so even if you can
export the JET Table Structure in SQL, you are unlikely to be able to use
the SQL to re-create the Table Structure in another database engine.

 

[Martin]

to your question
I want to export the table structurese to SQL, to backup the structure, when
is needed, I can re-create all structure.
Access DB size is in some case bloat (?) and we can not compress it (I know
some cases, and they are problems of Access 2k).
I can export Forms, Queries, modules... in Text files and restore them, but
Tables only data (?)

When you know anyway, how I export structure of tables without data, and
restore them (complete with indexes, relations), tell me please.

Thanks
Martin

 

[Van T. Dinh]

(Have you split the database to Front-End and Back-End?)

You can create a blank database and import all objects from the existing
database to the blank database. For the Tables, you can select either
"Structure and Data" or "Structure Only" and you also have the option to
import relationships. With the 2nd option you get the structure all Tables
but they have no Records. You can also import Queries Forms, Reports,
etc... ready just in case so there is no need to use Text files!

OTOH, you should always do regular back-ups of the whole database file
(including data!), anyway.

All databases will bloat as they use temporary space in the file. Regarding
A2000, I have a client company who have used an A2000 database for more 3
years without any problems since SR-1 was patched to heir PCs. The database
got corrupted once because of power interruption which was repaired
successfully. The original version of A2000 was bugsy but with proper
application of SRs, SPs, it is quite reliable AFAIK.

 

[Martin]

OK, I know it.
But I am form VB, C++ world, I would like see my code in visible text. And
Access does it too, when you use MS V Source Safe (together with Access for
developer). This is very good, when you want to compare 2 code versions or
search & replace (also in query and Tables structure) ...

Thanks anyway
Martin

 

[Van T. Dinh]

Yes, VSS stores them as some sort of text but it is certainly not SQL.

 

[Martin]

OK, not in SQL, I don't mean so. I mean only with queries, Forms .., and
the the tables save access in binary file together with another objects
(such as toolbars). And that is what I don't like, I search for a tool,
which....
I have wrote a tool, which "export" table structure in DAO code, but it
works only with structure, not relations, ....

 

[Van T. Dinh]

I am sure there are Relations Collection and Relation Object in DAO. I
hardly ever use them though so I am not sure whether they are suitanle for
your use.

 

[Martin]

My english is too bad, I cannot clearly say, what I think
With "but it works only with structure, not relations, ...." I mean "but
this tool (which I wrote) works only with ...", I don't lke to continue with
this work, I don't have much work with access more, I don't want to invest
much time in it.

Thanks
..