Thanks a lot, found it

rdb_default_value and rdb_default_source

--- In firebird-support@yahoogroups.com, "venussoftop" <venussoftop@...> wrote:
>
> Hi all
>
> I have a SP which has the following parameters
> CREATE PROCEDURE RECEIPTNARRATIONACCOUNTS (
> TITRID ID,
> TISRFID ID,
> TCPROMPT Varchar(4096) DEFAULT NULL,
> TCSEP Varchar(250) DEFAULT NULL )
> RETURNS (....
>
> I can find out the parameters (for all SPs) using the following query
> SELECT *
> FROM rdb$procedure_parameters
> ORDER BY rdb$parameter_number
>
> But somehow I cannot distinguish between the first 2 parameters and the next 2 parameters in terms of DEFAULT NULL.
>
> If there any other system table that might give distinguish this for me. Hope I was able to explain my needs.
>
> Thanks and regards
> Bhavbhuti
>