>>I'm not entirely sure this is what I'm looking for. Let me elaborate.
>>
>>I'm the sole VFP programmer on a team of developers. No one else has any VFP experience. We have a client across
>>town who we are doig changes for.
>>
>>I'm creating PRG's to modify table structures. This is the same thing you would do with SQL Server - create
>>scripts to create, update or drop tables at the client site.
>>
>>Since these changes are effecting tables which have views asscoiated with them, I need a simple solution along
>>the idea of a script that anyone can run, with little or no VFP experience.
>
>Kevin,
>
>You would need to re-create the view with CREATE VIEW command. If you need to know which views are affected by your changes, give me a sec, there was a program I used.

Yes, I would like that.

Is there any way of creating a CREATE VIEW command for an existing view? If so, I could make table changes here at
the office, generate a list of views which need updating using your PRG, generate the CREATE VIEW code for each
view into a single PRG, then run it at the client site to update the DBC.