Hi!

You can use COPY STRUCTURE EXTENDED comand to copy structure of both tables into new information tables holding records for each field. Then using these tables in a single query you can determine differences:

SELECT T1.*, "Does not match" as Difference_Type ;
  From TableOneStructure T1 ;
  inner TableTwoStructure T2 ;
    on T1.FIELD_NAME==t2.FIELD_NAME ;
  where NOT (T1.FIELD_TYPE==T2.FIELD_TYPE AND T1.FIELD_LEN = T2.FIELD_LEN AND ...) ;
UNION ALL ;
SELECT T1.*, "In table1 and not in table2" as Difference_Type From TableOneStructure T1 ;
  where T1.FIELD_NAME NOT IN (Select FIELD_NAME from TableTwoStructure) ;
UNION ALL ;
SELECT T2.*, "In table2 and not in table1" as Difference_Type From TableTwoStructure T2 ;
  where T2.FIELD_NAME NOT IN (Select FIELD_NAME from TableOneStructure) ;

The structure of table created by COPY STRUCTURE EXTENDED command see in teh MSDN help for this command.

Did not tested a query, but the idea is like that...

HTH.

>Hello all,
>
>Is there a command to compare the structures of 2 different
>.dbf tables? or do I have to do AFIELDS() for each table
>then ASCAN the data?
>
>Thanks.