skounis/table-size.sql

Created February 23, 2022 15:52

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/skounis/f9efc1410fb2fbd6697602caa9314c4e.js"></script>
Save skounis/f9efc1410fb2fbd6697602caa9314c4e to your computer and use it in GitHub Desktop.

Download ZIP

Show the records of all tables

Raw

table-size.sql

SELECT table_name, table_rows FROM INFORMATION_SCHEMA.TABLES [WHERE TABLE_SCHEMA = '**YOUR SCHEMA**';]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment