Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to specify the collation for a character data type in ms sql server?
What are the different acid properties?
How to execute a stored procedure in ms sql server?
What is transaction server explicit transaction?
Is it possible for a stored procedure to call itself or recursive stored procedure?
What is use of except clause? How does it differ from not in clause?
What is the default Port No on which SQL Server listens?
Explain ms sql server reporting services vs crystal reports?
How to include date and time values in sql statements?
What happens if null values are involved in boolean operations?
What area unit the various kinds of info compression introduced in sql server 2008?
Explain features of analysis services?
Can a cursor be updated? If yes, how you can protect which columns are updated?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What is sql stored procedure?
