GET LIST OF TABLES WITH ROWS COUNT in SQL SERVER

 SELECT o.NAME,

  i.rowcnt 

FROM sysindexes AS i

  INNER JOIN sysobjects AS o ON i.id = o.id 

WHERE i.indid < 2  AND OBJECTPROPERTY(o.id, 'IsMSShipped') = 0

ORDER BY i.rowcnt desc

Comments

Popular posts from this blog

Uploading Image to Sql Server Image Datatype in asp.net using fileupload Control

📉 Study: African Women Face Higher Risk of Job Loss to AI in Outsourcing Sector

🎨 Is There a Future for Graphic Designers in the AI Era?