Subject | Create views in prod fdb based on a sample fdb |
---|---|
Author | venussoftop |
Post date | 2009-12-31T17:53:17Z |
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
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