View "Create table" statement of an existing table

[Kim Tran]

I use the wizard to create tables. Now I would like to look at the SQL statements that create these tables. How do I do that? Thanks.

 

[Albert D. Kallal]

The statements to create tables are not saved anywhere, so...no this info is
not available.

If you are using a adp project, the tables you create are saved on sql
server. I believe you can use sql server to generate a script that would in
effect show the ddl statements used to create the table...but this is kind
of "after" the fact. Hence, not even sql server saves the statements you use
to create the tables, but it certainly can generate the scripts that would
produce the same tables.

If you not use a adp project, then of course you are not using sql server,
but using the JET engine. In the case of using the JET database engine, the
ddl statements used are not saved, but there is no script, or ddl generator
available either. In fact, I am not even sure if ddl statements are used
when creating tables for a JET database.

 

[Dirk Goldgar]

The statements to create tables are not saved anywhere, so...no this
info is not available.

If you are using a adp project, the tables you create are saved on sql
server. I believe you can use sql server to generate a script that
would in effect show the ddl statements used to create the
table...but this is kind of "after" the fact. Hence, not even sql
server saves the statements you use to create the tables, but it
certainly can generate the scripts that would produce the same tables.

If you not use a adp project, then of course you are not using sql
server, but using the JET engine. In the case of using the JET
database engine, the ddl statements used are not saved, but there is
no script, or ddl generator available either. In fact, I am not even
sure if ddl statements are used when creating tables for a JET
database.

It would be possible, of course, to write code to examine the tables
using DAO objects and generate SQL DDL statements to recreate them, at
least in the most basic way. The special properties that are created by
Access are a different story, though.

Probably someone has written this already. I'd check the Microsoft
KnowledgeBase, the FMS web site (to see if they have a tool to do it),
and do Google and Google Groups searches for posted code.

 

[Albert D. Kallal]

Probably someone has written this already. I'd check the Microsoft

KnowledgeBase, the FMS web site (to see if they have a tool to do it),
and do Google and Google Groups searches for posted code.

Yes...there is a number of people who have done this. In addtion, tools such
as Viso will take the access tables and generate ddl scripts that are
useable with sql server.

 

[Douglas J. Steele]

It would be possible, of course, to write code to examine the tables
using DAO objects and generate SQL DDL statements to recreate them, at
least in the most basic way. The special properties that are created by
Access are a different story, though.

Probably someone has written this already. I'd check the Microsoft
KnowledgeBase, the FMS web site (to see if they have a tool to do it),
and do Google and Google Groups searches for posted code.

I think there may be something relevant at http://www.ssw.com.au/ssw as
well.

 

[jyy]

3123123123123123123

I think there may be something relevant at http://www.ssw.com.au/ssw as
well.