sql query to show all databases code example Example 1: show databases in sql server SELECT * FROM SYS.DATABASES Example 2: show databases in sql server EXEC SP_DATABASES