Re: Getting a Database List

No, the equivalent is a schema.
Jim
"Steve M" <steve.mcdaniels_at_vuinteractive.com> wrote in message news:ahpitc$rdv$1_at_spiney.sierra.com...
> The Oracle instance IS the database.
> The MS-SQL equivalent to "database" is TABLESPACE.
>
> As user SYSTEM:
>
> select name from V$TABLESPACE;
>
>
> "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 Fri Jul 26 2002 - 04:58:40 CEST