Here is something that might work.

Select RDG$RELATION NAME FROM RDB$RELATIONS
Where RDB$SYSTEM_FLAG=0 or
RDB$SYSTEM_FLAG IS NULL AND
RDB$VIEW_SOURCE IS NULL
ORDER BY RDB$RELATION_NAME

Mo

""nevillerichards"" <neville@...> wrote in message
news:000a01c30821$c696f230$a5093c3e@DellAugust2002...

> This may be a very simple question,
>
> but is there a method in IB_Commection which will supply a list of (user)

tables in a database,

>
> if not, how is it best done?
>
> Neville
>
>
> [Non-text portions of this message have been removed]
>
>
>
>

___________________________________________________________________________

> IB Objects - direct, complete, custom connectivity to Firebird or

InterBase

> without the need for BDE, ODBC or any other layer.
>

___________________________________________________________________________

> http://www.ibobjects.com - your IBO community resource for Tech Info

papers,

> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>