--- In firebird-support@yahoogroups.com, "nols_smit" <nols@g...> wrote:

> Hi,
>
> I would like to programmatically extract the names of the views in a
> database and then extract each view's syntax as strings.
>
> Any suggestions?
>
>
> Regards,

To get all views:

SELECT * FROM RDB$VIEW_RELATIONS

to get the source:

SELECT rdb$view_source FROM rdb$relations
WHERE rdb$relation_name = '<view-name>'

Thomas