MSSQL.get_row_count
- MSSQL.get_row_count(table_name, schema_name=None)
Get row count of a table in a database.
- Parameters
table_name (str) – name of a table in the currently-connected database
schema_name (str or None) – schema name of the given table, defaults to
None
- Returns
count of rows in the given table
- Return type
int
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_row_count(table_name='MSreplication_options') 3