Skip to content

Recursive Erudition

Learn -> Teach -> Learn

tsql

November 18, 2008 Josh Rivers

Get the row count from each table in a database

Just an SQL Snippet for today:

createtable #rowcount (tablename varchar(128),rowcnt int)exec sp_MSforeachtable ‘insertinto #rowcount select ”?”,count(*) from ?‘ select * from#rowcount order by rowcnt desc drop table #rowcount

Recent Posts

  • WordPress Disk Usage
  • Setting up my new Unifi Network with separate IOT and Guest networks
  • Let’s Encrypt Update
  • WordPress Update Day
  • Upgrade Unbootable

Archives

  • December 2022
  • November 2021
  • January 2021
  • December 2020
  • November 2020
  • January 2018
  • December 2017
  • January 2016
  • September 2015
  • July 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • September 2014
  • October 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • December 2012
  • June 2012
  • January 2012
  • November 2011
  • July 2011
  • December 2010
  • November 2010
  • October 2010
  • October 2009
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • February 2009
  • January 2009
  • December 2008
  • November 2008
  • October 2008
  • September 2008

Categories

  • Posts

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Proudly powered by WordPress — Theme: Sequential by WordPress.com.