How to get number of row in each table in database

Posted by Suthahar on Friday, January 21, 2011 No comments

SELECT obj.NAME, ind.rowcnt FROM sysindexes AS ind INNER JOIN sysobjects AS obj ON ind.id = obj.id WHERE ind.indid < 2 AND OBJECTPROPERTY(obj.id, 'IsMSShipped') = 0 ORDER BY obj.NAME

Tags

Suthahar Jegatheesan is Mobile and Cloud Specialist/Architect and he has 15+ years of IT experience as a Technology Consultant /Programmer/Developer in IT industry. Suthahar is an industry luminary focused on AI, Computer Vision, Bot, Machine Learning, UWP, Azure, Xamarin and Web Emerging User Experiences as subject matter expert (SME) in implementation, architecture, development and administration.
Facebook
Google+
Linkedin
Pinterest
Delicious

0 Comments

Featured Post

C# Object and Dynamic Types

This blog provides an in-depth explanation of object and dynamic types in C#. Object Type 1. Overview object ...

MSDEVBUILD - English Channel

MSDEVBUILD - Tamil Channel

Popular Posts