para contar los registros de las tablas podrias usar:
Código SQL:
Ver originalSELECT SUM(total) FROM (
SELECT COUNT(*) AS total FROM tabla1
UNION
SELECT COUNT(*) AS total FROM tabla2
UNION
SELECT COUNT(*) AS total FROM tabla3
.
.
.
SELECT COUNT(*) AS total FROM tablaN
) AS t1