Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

plsease suport count #4549

Closed
hktalent opened this issue Nov 6, 2018 · 3 comments
Closed

plsease suport count #4549

hktalent opened this issue Nov 6, 2018 · 3 comments

Comments

@hktalent
Copy link

hktalent commented Nov 6, 2018

oracle

select owner,TABLE_NAME,NUM_ROWS from all_tables where not 'CHANGE_ON_INSTALL,CTXSYS,DBSNMP,INTERNAL,LBACSYS,MANAGER,MDSYS,MTRPW,MTSSYS,ODM,ODM_MTR,OLAPSYS,ORACLE,ORDPLUGINS,ORDSYS,OUTLN,SCOTT,SYS,SYSTEM,TIGER' like '%'\|\|owner\|\|'%'  and num_rows>1000 and not (table_name like '%LOG%' or  table_name like '%$%' or table_name like '%BAK%' or table_name like '%TMP%' or table_name like '%TEMP%' or table_name like '%TEST%') order by num_rows desc;

mysql

use information_schema;
select table_name,table_rows from tables order by table_rows desc

#server

SELECT  a.name AS [TABLE NAME] ,
        b.rows AS [RECORD COUNT]
FROM    sysobjects AS a
        INNER JOIN sysindexes AS b ON a.id = b.id
WHERE   ( a.type = 'u' )
        AND ( b.indid IN ( 0, 1 ) )
ORDER BY 
        b.rows DESC
@serge-rider
Copy link
Member

DBeaver already supports row count for all databases (by select count(*)) + statistical row count for Oracle, mySQL, PostgreSQL, DB2 and some others.
But you need to enable "slow" properties reading to see them in table lists:

image

@hktalent
Copy link
Author

hktalent commented Nov 7, 2018

if "show row count for tabele"
add
"sort by desc count"
"default sort by table name"

thanks @serge-rider

@hktalent hktalent closed this as completed Nov 7, 2018
@serge-rider
Copy link
Member

You can sort table by any column (just click on the column in header)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants