Hello,

>
> > > You can only get users logged in into a specific database
> > > by using the Services API.
> >
> > This means that one cannot also get thelist of all the databases
> > present on the DataServer (this is separate computer).
>
> Correct, Firebird doesn't know about datafiles unless
> you tell it to attach to them.
>

In MS SQL (Which I have used once very extensively) I am used to this
feature. We get the complete list of all the database present on the
server.

Looking from another angle this is good thing.

BTW where does FB store its data files on the server?

> > > by issueing:
> > > select * from rdb$relations where rdb$view_blr is null
> > > and rdb$system_flag is null or rdb$system_flag = 0
> >
> > This means I will have to mess with SystemTable for this. That is a
> > bit frightning for me as I am a beginner in FB.
> >
> > Isn't there SQL Select facility like 'SELECT * FROM Tab' to retrive a
> > list of all the Tables in a database?
>
> What would "Tab" be in this case? I'm telling you, it's RDB$RELATIONS.

I got what you are telling me. I am just suggesting that there should
be a predefined SELECT statement which returns a dataset which is
readonly.

That is all!

>
> Selecting from system tables is no problem, it's done in many systems.
>
> If you're scared, just create this view :-)
>
> CREATE VIEW ALL_TABLES AS
> select * from rdb$relations where rdb$view_blr is null
> and rdb$system_flag is null or rdb$system_flag = 0
>
> and it will look just like Oracle ;)

Thank you for the hint.

>
>
> > See rdb$relation_fields
> > >
> >
> > Again it is frightining to mess with System Table.
> >
> > I think there should be some facility for retriving the complete
> > Schema of a Database.
>
> See above. The system tables is where all the info is.
>
> > Does any know of any such Undocumented function or has any created any
> > UDF for this?
>
> UDFs cannot return resultsets.

Oh! I did not know about that.

Thanks again.

Yogi Yang