comparing the datastructure of two tables

[windandwaves]

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

[Douglas J. Steele]

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" <winan...@coldmail.com> wrote in message
news:4296...@clear.net.nz...

[windandwaves]

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