Subject | Re: a few How To......s |
---|---|
Author | yogiyang007 |
Post date | 2007-04-19T07:49:52Z |
Hi,
present on the DataServer (this is separate computer).
databases that exist. That is bad news for me.
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?
I think there should be some facility for retriving the complete
Schema of a Database.
Does any know of any such Undocumented function or has any created any
UDF for this?
Thanks for your Help.
>This means that one cannot also get thelist of all the databases
> You can only get users logged in into a specific database
> by using the Services API.
>
present on the DataServer (this is separate computer).
>If we cannot retry aliases.conf file we cannot find the actual
> Firebird doesn't have registered databases on the server
> side. It does have the "aliasses.conf" file, but as far as I
> know, you cannot retrieve the list from the client.
databases that exist. That is bad news for me.
>This means I will have to mess with SystemTable for this. That is a
>
> by issueing:
> select * from rdb$relations where rdb$view_blr is null
> and rdb$system_flag is null or rdb$system_flag = 0
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?
>Again it is frightining to mess with System Table.
> See rdb$relation_fields
>
I think there should be some facility for retriving the complete
Schema of a Database.
Does any know of any such Undocumented function or has any created any
UDF for this?
Thanks for your Help.