Re: Getting a Database List

apparently you haven't worked much with MS-Sql.

"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:AV209.647237$352.137164_at_sccrnsc02...
> 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 - 20:06:58 CEST