Answer Posted / manoj savalia
Try This
SELECT SYS_OBJ.NAME AS "TABLE NAME"
, SYS_INDX.ROWCNT AS "ROW COUNT"
FROM SYSOBJECTS SYS_OBJ, SYSINDEXES SYS_INDX
WHERE SYS_INDX.ID = SYS_OBJ.ID
AND INDID IN(0,1)
AND XTYPE = 'U'
AND SYS_OBJ.NAME <> 'SYSDIAGRAMS'
AND SYS_INDX.ROWCNT>0
ORDER BY SYS_INDX.rowcnt DESC
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Data table as parameter in sql server?
What do you understand by the data quality services in sql server?
Explain the stored procedure?
How many cores do I need for sql server 2016?
What are the differences between union, intersect, and minus operators?
What are functions in the sql server?
Why do you need a sql server?
How do you debug a procedure in sql server?
What is the recursive stored procedure in sql server?
How you can get the list of largest tables in a database?
How does a profiler work?
Equi join and non equi join is possible with sql server?
What is difference between stored procedure and user defined function?
Explain different backup plans?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
