how to show all databases in sql code example

Example 1: show databases in sql server

SELECT * FROM SYS.DATABASES

Example 2: show sql server database

EXEC sp_databases

Example 3: show databases in sql server

EXEC SP_DATABASES