query to list databases on the current server code example

Example 1: show databases in sql server

EXEC SP_DATABASES

Example 2: show databases in sql server

SELECT name FROM master.SYS.DATABASES