MSSQL.get_column_names

MSSQL.get_column_names(table_name, schema_name=None)[source]

Get column names of a table.

Parameters:

table_name (str) – name of a table in the currently-connected database
schema_name (str | 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()
{'dbo': ['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']