How can I get all the database names in a sql server instance using tsql?

Solution

SELECT * FROM sys.databases