List SQL Server databases

This C# code snippet displays all the SQL Server database names.

	using System.Data;
	using System.Data.SqlClient;
	// Substitute your connection string below in conxString
	String conxString = "Data Source=MYSERVER; Integrated Security=True;";
	using (SqlConnection sqlConx = new SqlConnection (conxString))
	{
	sqlConx.Open();
	DataTable tblDatabases = sqlConx.GetSchema ("Databases");
	sqlConx.Close();
	foreach (DataRow row in tblDatabases.Rows)
	{
	Console.WriteLine ("Database: " + row["database_name"]);
	}
	}

view raw List SQL Server databases.cs hosted with ❤ by GitHub