MSSQL.get_table_names

MSSQL.get_table_names(schema_name=None)

Get names of all tables stored in a schema.

Parameters

schema_name (str or list or None) – name of a schema, defaults to DEFAULT_SCHEMA when schema_name=None

Returns

names of tables in the given schema mssql_schema_name

Return type

list

Examples:

>>> from pyhelpers.dbms import MSSQL

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

>>> mssql.get_table_names()
['MSreplication_options',
 'spt_fallback_db',
 'spt_fallback_dev',
 'spt_fallback_usg',
 'spt_monitor']

>>> mssql.get_table_names(schema_name=['dbo', 'sys'])