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