Re: Getting a Database List
From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Thu, 25 Jul 2002 04:01:40 GMT
Message-ID: <EKK%8.653708$cQ3.105580_at_sccrnsc01>
Date: Thu, 25 Jul 2002 04:01:40 GMT
Message-ID: <EKK%8.653708$cQ3.105580_at_sccrnsc01>
You actually probably mean schemas for Oracle.
Jim
"Lee" <lee_at_dev.null.com> wrote in message
news:3d3f6464_at_news.starhub.net.sg...
> I need to know the interactive SQL syntax to get a listing of databases on
> the current server.
>
> Using Informix, the commands would be:
> database sysmaster;
> select name from sysdatabases;
>
> MySQL:
> show databases;
>
> MS-SQL:
> SELECT name FROM master..sysdatabases ORDER BY name
>
> Please reply by posting to this newsgroup. My email address is hashed to
> protect me from spamming.
>
> Thanks,
> Lee
>
>
>
>
Received on Thu Jul 25 2002 - 06:01:40 CEST