Thanks Helen, it works just fine:-))

Helen Borrie wrote:

>
> At 07:01 PM 17/07/2006, you wrote:
> >How do I extract the path of the External Table using SQL?
>
> select rdb$external_file from rdb$relations
> where rdb$relation_name starting with 'MYEXTTBL'
>
> ./heLen
>
>