In this post, we will learn about how to get all tables records count from the selected database. Here we are using sys.objects and sys.partitions for getting the record count. Here we are using join sys.objects with sys.partitions from sys.partitions we can get row count of table and sys.objects will return the name of a schema (table name).
source https://www.c-sharpcorner.com/Blogs/how-to-get-all-row-count-for-all-tables-in-sql-server-database
No comments:
Post a Comment