> To get all views:
>
> SELECT * FROM RDB$VIEW_RELATIONS

distinct(rdb$view_name)

would work. RDB$VIEW_RELATIONS lists something
other then "just views".

With regards,

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