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