DEV Community

Cover image for SQL-Quick tip #9 - Number of rows in all tables
Allan Simonsen
Allan Simonsen

Posted on

3 2

SQL-Quick tip #9 - Number of rows in all tables

Sql Server tips and tricks

This is part of a series of quick tips and tricks I have accumulated over the year, that I think can be useful for others.
If you have similar short tips and tricks please leave a comment.

Number of rows in all tables

When you start to work on a project for a new customer a good piece of information is how many tables does the database contain and how many rows are there in each table. Or maybe you don't have access to the production database and need to send a service request to the IT operations department to get information about the production database.
Then the query below will useful to you.

SELECT SCHEMA_NAME(sOBJ.schema_id) + '.' + sOBJ.name AS [Table name],
       SUM(sPTN.Rows) AS [Row count]
  FROM sys.objects AS sOBJ
  JOIN sys.partitions AS sPTN ON sOBJ.object_id = sPTN.object_id
 WHERE sOBJ.type = 'U'
   AND sOBJ.is_ms_shipped = 0x0
   AND index_id < 2 -- 0:Heap, 1:Clustered
 GROUP BY sOBJ.schema_id, sOBJ.name
 ORDER BY [Table name]
Enter fullscreen mode Exit fullscreen mode

Sql Server Management Studio screenshot

Image of Timescale

🚀 pgai Vectorizer: SQLAlchemy and LiteLLM Make Vector Search Simple

We built pgai Vectorizer to simplify embedding management for AI applications—without needing a separate database or complex infrastructure. Since launch, developers have created over 3,000 vectorizers on Timescale Cloud, with many more self-hosted.

Read more →

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more