By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,488 Members | 2,545 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,488 IT Pros & Developers. It's quick & easy.

export DDL for tables from Access 2000

P: n/a
Hello,

I have an Access 2000 database with several tables I'm using for a
project. I'd like a way, if possible, to get the actual DDL used for all
the tables in the database. For example, if I have a table called
Customers, I'm looking for the associated "CREATE TABLE Customers ( ...
)" DDL in one file. Is this possible?

Thanks for your time.

--
Mike
May 5 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
You would have to build it dynamically.

There used to be a tool on the web for doing this have a search on google.

--

Terry Kreft
"Mike" <no****@comcast.net> wrote in message
news:S9********************@comcast.com...
Hello,

I have an Access 2000 database with several tables I'm using for a
project. I'd like a way, if possible, to get the actual DDL used for all
the tables in the database. For example, if I have a table called
Customers, I'm looking for the associated "CREATE TABLE Customers ( ...
)" DDL in one file. Is this possible?

Thanks for your time.

--
Mike

May 5 '06 #2

P: n/a
I have not seen any scripting tools for performing this type of
operation in Access like you can in sql server. There IS the Documenter
on the toolbar for the Database window which shows all the fields and
properties of tables and other objects. But that is not DDL. I don't
believe Access has a scripting tool like Sql Server - yet.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
May 5 '06 #3

P: n/a
Mike wrote:
Hello,

I have an Access 2000 database with several tables I'm using for a
project. I'd like a way, if possible, to get the actual DDL used for all
the tables in the database. For example, if I have a table called
Customers, I'm looking for the associated "CREATE TABLE Customers ( ...
)" DDL in one file. Is this possible?

Thanks for your time.

Thanks to all that responded.

--
Mike
May 5 '06 #4

P: n/a
On Fri, 05 May 2006 10:04:04 -0400, Mike <no****@comcast.net> wrote:
Hello,

I have an Access 2000 database with several tables I'm using for a
project. I'd like a way, if possible, to get the actual DDL used for all
the tables in the database. For example, if I have a table called
Customers, I'm looking for the associated "CREATE TABLE Customers ( ...
)" DDL in one file. Is this possible?

Thanks for your time.


see recent thread
http://groups.google.co.uk/group/com...8fa736cc53ded9
May 5 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.