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

comparing the datastructure of two tables

P: n/a
Hi Guys

I want to find out if two tables are identical (e.g. same fields, same
indexes, etc....). Not the data, but the table structure itself.

Is there a smart way to do that?

Cheers
Nicolaas
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
There are 3rd party tools that'll help you with this.

Take a look at FMS http://www.fmsinc.com or SSW
http://www.ssw.com.au/SSW/Products/ProdSummaryList.aspx or
http://www.kliksoft.com/

Otherwise, you'll need to loop through every field in every table, comparing
every property.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"windandwaves" <wi*********@coldmail.com> wrote in message
news:42******@clear.net.nz...
Hi Guys

I want to find out if two tables are identical (e.g. same fields, same
indexes, etc....). Not the data, but the table structure itself.

Is there a smart way to do that?

Cheers
Nicolaas

Nov 13 '05 #2

P: n/a
Douglas J. Steele wrote:
There are 3rd party tools that'll help you with this.

Take a look at FMS http://www.fmsinc.com or SSW
http://www.ssw.com.au/SSW/Products/ProdSummaryList.aspx or
http://www.kliksoft.com/

Otherwise, you'll need to loop through every field in every table,
comparing every property.


Hi Douglas,

thanks for that, those tools are awesome. I am going to write it myself
first and if it does not work I am going to try to get some of those
tools.... (I prefer to know how things work....)

Thanks a lot.

- Nicolaas
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.