MSSQL.get_column_names

MSSQL.get_column_names(table_name, schema_name=None)

Get column names of a table.

Parameters

• table_name (str) – name of a table in the currently-connected database

• schema_name (str or None) – defaults to None

Returns

a list of column names

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_column_names(table_name='MSreplication_options')
['optname',
 'value',
 'major_version',
 'minor_version',
 'revision',
 'install_failures']