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