Jimi

take a look at CREATE SQL VIEW.

Also take a look at eview a utility in the downloads section that will help you maintain you views or create code to maintain your views.

Nick Mason

>hello everybody,
>
>I have two databases, one contains a set of free tables and another contains a set of views. Each view in the 2nd database is refering to a table in the 1st database.
>
>Now I need to alter the structure of some tables in my program, after that the relative views' update criteria will be reset and need to set again. I am not allowed to modify the views in the project manager, but I dunno how to do this in program code.
>
>What command should I use? Or where can I get relevant information? Thanks very much!
>
>Jimi