Subject Re: [Firebird-Java] Text of a view and text of a stored procedure
Author Ann W. Harrison
At 03:31 PM 8/17/2004, Monstrous Megabytes wrote:
>Hi,
>
>I am trying to find the actual contents of a view and a stored procedure. Is
>there a way I can do this? If I am posting to the wrong group please let me
>know.

The system table RDB$RELATIONS includes a field RDB$VIEW_SOURCE. You'll find
the selection expression for the view there. Similarly, RDB$PROCEDURES
includes
RDB$PROCEDURE_SOURCE. Both fields are optional, set by default.

Regards,


Ann