I posted too soon! I figured out that I can use the VFP functions:
SQLTables() and SQLColumns() to extract the structures of the sql server tables and then dynamically generate my remote views.

thanks....

>Hello...
>
>Does anyone know of a way to query a sql server database and generate views. Or re-generate existing views if underlying sql structure has changed? I have looked at some of the sql server system tables, like syscolumns, and it appears that I will need to create a program to query those system tables to construct the structure of each table and then create my vfp remote view. However, I was wondering (and hoping) if anyone else has done this before or knows of a better solution.
>
>Thanks...Douglas