Description

SHOW TABLECOUNT returns the number of rows of all tables.

Syntax

Syntax

SHOW TABLECOUNT [<table>] 
BASH

<table>

When you define a table, it returns the number of rows of the given table.

Output

ColumnNamedescription
schemaschema name
tabletable name
linesNumber of rows