Getting database names from MSSQL?

Question

C++ / C#

Hello!
There is a database on MSSQL. You need to create a class in C # that receives names, id database and assign it to an array, and then display the array on the Listbox. When the user selects the required database (listBox_SelectedIndexChanged), another form opens and all tables of the selected database are loaded.
Can you tell me how to do it? Thank you!

Answer 1

The list of databases can be obtained from sysdatabases:
List of tables - well, let's say from sys.tables:
SELECT [name] FROM sys.tables;