Edit - Stack Overflow

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

Rev

3

Thanks, I was hoping I wouldn't have to install any plugins/gems to get exact counts.

bradvido
– bradvido

2014-09-02 20:02:11 +00:00
Commented Sep 2, 2014 at 20:02
1

Takes too long to execute in case of large number of tables in the database.

ollamh
– ollamh

2018-05-15 07:13:48 +00:00
Commented May 15, 2018 at 7:13
2

add "select * from (" at beginning and ") as output order by exact_row_count desc" at the end of generated query after removing last UNION to get order by table count desc

Raghavendra
– Raghavendra

2018-06-22 05:42:06 +00:00
Commented Jun 22, 2018 at 5:42
3

To exclude views: WHERE table_schema = 'my_schema' and TABLE_TYPE LIKE '%TABLE%'

Watson
– Watson

2019-07-27 00:42:37 +00:00
Commented Jul 27, 2019 at 0:42
3

This is THE real answer for me.

Abhijeet Nagre
– Abhijeet Nagre

2020-07-18 13:48:02 +00:00
Commented Jul 18, 2020 at 13:48

Add a comment |

Correct minor typos or mistakes
Clarify meaning without changing it
Add related resources or links
Always respect the author’s intent
Don’t use edits to reply to the author

create code fences with backticks ` or tildes ~
```
like so
```
add language identifier to highlight code
```python
def function(foo):
print(foo)
```
put returns between paragraphs
for linebreak add 2 spaces at end
_italic_ or **bold**
indent code by 4 spaces
backtick escapes `like _so_`
quote by placing > at start of line
to make links (use https whenever possible)

<https://example.com>

[example](https://example.com)

<a href="https://example.com">example</a>

formatting help »
answering help »

Collectives™ on Stack Overflow