SHOW TABLECOUNT
Description
SHOW TABLECOUNT returns the number of rows of all tables.
Syntax
Syntax
BASH
SHOW TABLECOUNT [<table>] <table>
if you specify a table name, it returns the number of rows of the given table.
Output
| ColumnName | description |
|---|---|
| schema | schema name |
| table | table name |
| lines | Number of rows in the table |
| live_lines_without_commit | Number of rows loaded and not yet committed |