TableDefs comparison

  • Thread starter Thread starter Chris Zoumas
  • Start date Start date
C

Chris Zoumas

I would like to check if the definitions of two tables in two databases
are the same. Is there any way to do this using TableDefs objects?

TIA Chris
 
There is an example of how to loop through the Fields of the TableDef, and
access their Properties at:
http://members.iinet.net.au/~allenbrowne/func-06.html

A comparison is fairly involved though. First is a comparion built-in
properties of the tables, followed by looping through the Properties
collection of both tables to compare the existence and values.

Next, you need to check for the existence of the fields in both of the
tables. Where found, compare their built-in properties such as Type, Size,
and Attributes, and then loop through the Properies collection of the field
in both tables to check for the existence and value of each one.

You would then need to loop through the Indexes collection of both tables,
again comparing the existence of the indexes, their built-in properties and
the existence and values of the Properties collection of both tables.
 
Back
Top