MSSQL.get_file_tables¶

MSSQL.get_file_tables(names_only=True)[source]¶

Retrieve information about FileTables from the database (if available).

Parameters:: names_only (bool) – Whether to return only the names of FileTables; defaults to True.
Returns:: Information about FileTables (if available).
Return type:: list | pandas.DataFrame

Examples:

>>> from pyhelpers.dbms import MSSQL
>>> mssql = MSSQL(verbose=True)
Connecting <server_name>@localhost:1433/master ... Successfully.
>>> mssql.get_file_tables()
[]