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']