Get list of databases from SQL Server

by

Execute:

SELECT name FROM master.sys.databases

This the preferred approach now, rather than dbo.sysdatabases, which has been deprecated for some time.

Execute this query:

SELECT name FROM master.dbo.sysdatabases

or if you prefer

EXEC sp_databases

More Related Contents:

  1. How can foreign key constraints be temporarily disabled using T-SQL?
  2. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  3. How to add Active Directory user group as login in SQL Server
  4. How to create materialized views in SQL Server?
  5. How do I format a number with commas in T-SQL?
  6. Combine two tables that have no common fields
  7. Is it possible to use Full Text Search (FTS) with LINQ?
  8. How to set a default value for an existing column
  9. Need a datetime column in SQL Server that automatically updates when the record is modified
  10. how to make your data horizontal
  11. How do I find a stored procedure containing ?
  12. Error: TCP Provider: Error code 0x2746. During the Sql setup in linux through terminal
  13. SQL Server: Database stuck in “Restoring” state
  14. How to check if a Constraint exists in Sql server?
  15. Access is denied when attaching a database
  16. Getting an odd error, SQL Server query using `WITH` clause
  17. An attempt to login using SQL authentication failed
  18. What does “ORDER BY (SELECT NULL)” mean?
  19. Calling stored procedure using VBA
  20. Split one column into multiple rows
  21. SQL Unique constraint across multiple tables
  22. How to find SQL Server running port?
  23. Changing SQL Server collation to case insensitive from case sensitive?
  24. SQLServer IDENTITY Column with text
  25. Why SQL Server DATETIME type saves time in ticks of 1/300 of a sec?
  26. How to store directory / hierarchy / tree structure in the database?
  27. Cannot bulk load. Operating system error code 5 (Access is denied.)
  28. Which is quicker COALESCE OR ISNULL?
  29. Merge multiple rows into a single row
  30. Does query plan optimizer works well with joined/filtered table-valued functions?

Leave a Comment