>>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.

See my other message. As for generating script for views, we used Steve Sawyer View Editor that had this option. I guess View SQL when you open the view gives you the same (I forgot). Running GenDBC and grabbing views creation from there is another option.