Registered DBs

[Ruslan Zasukhin]

On 5/17/12 6:41 PM, "Bart Pietercil" <bart.pietercil at cognosis.be> wrote:

>  
>  Hi Fabian, 
> 
> I think 
> show databases
> is the closed you will get.

agree

> This returns the name of the registered databases.
> On the other hand you can always define a property on the database that stores
> the path as a workaround and combine show database with property 'full_path'
> of database x


>> On Thursday 17 May 2012 at 16:56, Fabian Kneubuehl wrote:
>>  
>> Hi,
>> 
>> Is it possible to retrieve all registered databases in VServer (names and
>> full  paths) via SQL?

Another way:

USE MASTER;
SELECT * FROM xxxx

Xxxx -- replace to name of table, which keep info about dbs.
Check it by vstudio



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]