>Hi,
>How to copy the tables and indexs from one table to other database under VFP9.

You can run home()+"tools\gendbc\gendbc" on the first database. It will generate all the code to recreate the database. You can run that code in a new directory, and it will create a database with tables just like they were in the old one. You can then append the data from the old one, one table at a time.