Skip to content

List all tables with size in a MySQL Database

SELECT
    TABLE_NAME,
    TABLE_ROWS
FROM
    `information_schema`.`tables`
WHERE
    `table_schema` = 'your_Schema';
See also  TypeScript code snippet - How to get all the elements in Hashtable java?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.