Subject Re: [firebird-support] Views
Author Martijn Tonies
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?

Look at system table RDB$RELATIONS - each row where
RDB$VIEW_BLR is NOT NULL, is a view. The view source
is available in RDB$VIEW_SOURCE.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com