I hope this is correct place for this ....
HI,
I am glad to have found this site!!!
If this is not the correct location, is there another location that i should be
posting this question ?
I know there are no 'systems' tables available in HUE, is there any way to
re-code this to get row counts for ALL tables ?
i have 416 tables in my database.
SELECT T.name AS [TABLE NAME], I.rows AS [ROWCOUNT]
FROM sys.tables AS T
INNER JOIN sys.sysindexes AS I
ON T.object_id = I.id
AND I.indid < 2
ORDER BY I.rows DESC
I thank you in advance for any assistance you can provide.
Bob
Thank you
Bob Gillespie
Attunity data landing team
ITEK - E2F008J
