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 | Alias/View/table name | ||||||||
| lines |
| ||||||||
| live_lines_without_commit | Number of rows loaded and not yet committed |