SELECT RDB$RELATION_NAME from RDB$RELATIONS
Where RDB$FLAGS=1

will give you all the tables in the Database (except system tables)

SELECT RDB$FIELD_NAME from RDB$RELATION_FIELDS
Where RDB$RELATION_NAME = :SomeTableName

will give you all the columns in a table, but then again you could use a
TIB_Query to retrieve the columns.

Rgds,
Costas Droussiotis


Mirko's wrote:

>
> Hi,
> With BDE I was able to retrieve the list of table and stored procedure
> using "Session.GetTableNames" and "Session.GetStoredProcNames".
> I look for the correspondent function in IBO but I don't find it,
> can somebody help me?
> Thank you
> Mirko Guidolin
>
>
> ___________________________________________________________________________
> 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/