Subject Re: [IBO] List of Tables
Author nevillerichards
Thanks Mo,

When I removed the couple of typographical errors, it worked fine. You
pointed me in the right direction. I was expecting something "for free" in
the components, but this isn't too much hassle.

Neville


> 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/
> >
> >
>
>
>
>
>
___________________________________________________________________________
> 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/
>
>
>