Sometime we want to get the Row Count quickly for all the tables in our Database for analysis. There are multiple ways to do that. We can use TSQL Cursor to loop through all the tables and use count(*) to get the row count.
Check out our other posts on Data Analysis / Data Validation / Data Cleansing
I am using Catalog views to get this information by using below query. This is quick way to find the row count for all the tables in a database. The Cursor with Count(*) can be slow as it has to count rows for each of the table.
USE YourDBName
GO
SELECT OBJECT_NAME(id) AS TableName, rowcnt AS [RowCount]
FROM sysindexes s INNER JOIN sys.tables t ON s.id = t.OBJECT_ID
WHERE s.indid IN ( 0, 1, 255 ) AND is_ms_shipped = 0
I ran above query on TestDB and got below information.
Fig 1: Get Row Count for all the Tables in SQL Server Database
Check out our other posts on Data Analysis / Data Validation / Data Cleansing
- How to Search in all Columns for all tables in a database for Date Value in SQL Server
- How to Find Percentage of Null Values in every Column of all the Tables in SQL Server Database
- How to Find Percentage of Empty or Blank Values in every Column of all the Tables in SQL Server Database
- How to search for a String in all Columns in all tables in SQL Server Database
- How to find and Replace Text in all the columns in all the tables in SQL server Database
- How to find values with Leading or Trailing Spaces in SQL Server Table
- How to Trim Leading and Trailing spaces for all the values in all the Columns in all the Tables in a SQL Server Database
- How to Find Duplicate Records in All the Tables in SQL Server Database
- How to Find & Delete Duplicate Records on All Tables in SQL Server Database
- How to Generate Select all Columns with or Without Top X Rows From All Tables Query Dynamically in SQL Server
- Concatenate SQL Server Columns for each Table Query Dynamically in SQL Server
- How to List all Missing Identity Values for all Tables in SQL Server Database
- How to Find Max and Min Values for all the columns for all the tables in SQL Server Database
While working on a SQL project to calculate the percentage of empty or null values across multiple columns, I found a helpful tutorial that streamlined my data analysis process. This efficiency in handling data led me to consider optimizing other aspects of my work, such as streaming services. I explored SoPlayer as a potential platform for flexible viewing options. To understand user experiences, I consulted https://soplayer.pissedconsumer.com/review.html , feedback highlighted the platform's variety of channels and user-friendly interface, which aligned with my entertainment needs. Embracing such solutions complements the ethos of enhancing efficiency and enjoyment in various facets of life.
ReplyDelete