Post reply

get list of databases

  • February 7, 2005 at 2:10 am

    #163533

    how to get list of all the databases in sql server through sql query?....

  • February 7, 2005 at 5:54 am

    #540905

    There are plenty of discussions here on how to do that.  I would try using the search option on the toolbar and type in list databases.

     



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • February 7, 2005 at 7:53 am

    #540933

    Here's a short query :

    Select dbid, name from master.dbo.SysDatabases

  • February 8, 2005 at 1:25 am

    #541071

    To avoid using system tables use the INFORMATION_SCHEMA objects:

    SELECT CATALOG_NAME

    FROM INFORMATION_SCHEMA.SCHEMATA

    If you need dbid:

    SELECT DB_ID(CATALOG_NAME), CATALOG_NAME

    FROM INFORMATION_SCHEMA.SCHEMATA

  • February 8, 2005 at 9:40 am

    #541161

    I would recommend that in future you try a different forum because your question has nothing to do with either SQL Server Yukon or Business Intelligence.

     

    Jamie Thomson
    http://sqlblog.com/blogs/jamie_thomson

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply