I really do not know what VFP is. Could you explain, please?
“I would like to create a csv file with the field_name, field_type, field_length and then have sqlyog create the schema.” The problem, please?? I do not see any!
“If there are other, similar, methods of accomplishing … ” Well then I think you must explain WHY you need this CSV file. Maybe ODBC import/migration, DATA SYNC are better options. But I cannot tell as long as I do not understand the 'project' …