get list of databases

• rainbow_22_1

  Grasshopper

  Points: 17

  More actions

  February 7, 2005 at 2:10 am

  #163533

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

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  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

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  February 7, 2005 at 7:53 am

  #540933

  Here's a short query :

  Select dbid, name from master.dbo.SysDatabases

• gbn

  SSCertifiable

  Points: 6429

  More actions

  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

• Jamie Thomson

  SSChampion

  Points: 11805

  More actions

  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