Mohit Agrawal

Success is Journey it's not a destination

Menu

  • Home
  • Sql server 2008
  • Differences

May 12, 2010

Sql Server : list of tables which have no records in a database.

select distinct o.name as TableName, x.rowcnt as Table_RowCount
from sysobjects o
inner join sysindexes x
on o.id = x.id
where x.rowcnt = 0 and x.groupid = 1
and o.type = 'U'
Posted by Mohit
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Sql Server

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Search This Blog

Index

  • ►  2017 (1)
    • ►  February (1)
  • ►  2016 (1)
    • ►  February (1)
  • ►  2014 (2)
    • ►  March (2)
  • ►  2013 (1)
    • ►  January (1)
  • ►  2012 (3)
    • ►  December (1)
    • ►  October (1)
    • ►  February (1)
  • ►  2011 (1)
    • ►  March (1)
  • ▼  2010 (4)
    • ▼  May (2)
      • Sql Server : list of tables which have no records ...
      • Sql Server: Use "Order by" clause in View
    • ►  March (2)
  • ►  2009 (22)
    • ►  November (1)
    • ►  October (6)
    • ►  August (3)
    • ►  July (2)
    • ►  June (3)
    • ►  May (3)
    • ►  March (4)
  • ►  2008 (17)
    • ►  December (1)
    • ►  September (1)
    • ►  August (1)
    • ►  April (2)
    • ►  February (12)
Mohit
View my complete profile

Blogs

  • AngularJS
  • Asp.net
  • Vb.net Link
  • Obect Oriented Programming
Ethereal theme. Powered by Blogger.