Subject Re: [firebird-support] udf returning database file path
Author Thomas Steinmaurer
> Is there any udf (or internal function) to get database file fullpath?
> for example: C:\MYFOLDER\MYBASE.FDB.
> It could be usefull to verify the base we are connected to, especially
> when an alias is specified during connect step.

- if you are using Firebird 2, and
- if you don't have DatabaseAccess = None set in firebird.conf

then the following SQL statement will give you the full path:

select rdb$get_context('SYSTEM', 'DB_NAME') from rdb$database

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions