query to list all databases in sql server code example

Example 1: show databases in sql server

SELECT * FROM SYS.DATABASES

Example 2: get database list in sql server

SELECT name FROM master.dbo.sysdatabases

Example 3: show databases in sql server

EXEC SP_DATABASES

Example 4: show databases in sql server

SELECT name FROM master.SYS.DATABASES

Tags:

Misc Example

Related