AX Senior Consultant

Tuesday, July 29, 2008

테이블들의 Row Count 가져오기!

SELECT [TableName] = so.name,
[RowCount] = MAX(si.rows)
FROM sysobjects so, sysindexes si
WHERE so.xtype = 'U' AND si.id = OBJECT_ID(so.name)
GROUP BY so.name ORDER BY 2 DESC
Posted by Alvin(Bongsub) You at 10:40 AM
Labels: SQL Server

No comments:

Post a Comment

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

About Me

My photo
Alvin(Bongsub) You
Seoul, South Korea
View my complete profile

Search This Blog

Blog Archive

  • ►  2013 (12)
    • ►  September (2)
    • ►  August (3)
    • ►  July (6)
    • ►  May (1)
  • ►  2012 (7)
    • ►  March (7)
  • ►  2011 (2)
    • ►  July (2)
  • ►  2010 (10)
    • ►  April (2)
    • ►  March (2)
    • ►  February (2)
    • ►  January (4)
  • ►  2009 (18)
    • ►  December (12)
    • ►  November (2)
    • ►  September (1)
    • ►  February (1)
    • ►  January (2)
  • ▼  2008 (15)
    • ►  December (5)
    • ►  November (4)
    • ►  September (3)
    • ▼  July (3)
      • Object(SP, UDF 등) 검색
      • 테이블들의 Row Count 가져오기!
      • 졸립다~ 흐!!
  • ►  2007 (3)
    • ►  September (3)

Labels

  • my Life
  • AX 2012
  • Documentum
  • SQL Server
  • Sharepoint
  • Book
  • DQL
  • Enterprise Portal
  • I♡Mt.
  • X++
  • Powershell
  • Tip
  • API
  • Articles
  • DFC
  • DFS
  • ECM
  • ERD
  • Eclipse
  • English
  • HVS
  • Java
  • LDAP
  • Retail POS
Simple theme. Powered by Blogger.