Subject Create views in prod fdb based on a sample fdb
Author venussoftop
Hi all

A Very Happy New Year to all!

I have a sample fdb that contains views. I need to duplicate the views (and it's dependent views) in the production fdb. I can SQL-Pass-Through from my VFP application to both these fdb. I have also located the 4 system tables that might help me with the task, but I am not sure where to start. They are as below:
RDB$VIEW_CONTEXT
RDB$RELATIONS
RDB$RELATION_FIELDS
RDB$DEPENDENCIES

Please advise.

Thanks and regards.
Bhavbhuti