MSSQL.get_database_names
- MSSQL.get_database_names(names_only=True)[source]
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']