MSSQL.get_database_names

MSSQL.get_database_names(names_only=True)

Get names of all existing databases.

Parameters

names_only (bool) – whether to return only the names of the databases, defaults to True

Returns

names of all existing databases

Return type

list or pandas.DataFrame

Examples:

>>> from pyhelpers.dbms import MSSQL

>>> mssql = MSSQL()
Connecting <server_name>@localhost:1433/master ... Successfully.

>>> mssql.get_database_names()
['master',
 'tempdb',
 'model',
 'msdb']