Records in a Table

Question

Records in a Table

jagjitsingh

Ten Centuries

Points: 1059
More actions
December 24, 2017 at 7:52 am

#330644

Hi
How we can get a list of all tables with No of records in a Database
Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

J Livingston SQL SSC Guru Points: 51550 More actions · Answer 1

try this ....lots of solutions if you care to search on the web.
https://www.mssqltips.com/sqlservertip/2537/sql-server-row-count-for-all-tables-in-a-database/

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 2

jagjitsingh - Sunday, December 24, 2017 7:52 AM
Hi
How we can get a list of all tables with No of records in a Database
Thanks

Now that you have an answer for your question, let's concentrate on the larger picture, which is currently missing. What will you do with knowing the rowcounts from every table? What is the larger task where such information will be used? I ask because there's always a larger task involved for such things and we may be able to help there a whole lot.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)