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