Everything AX: How to quickly get table row counts in Axapta

[Blog bot]

Источник: http://www.crankturner.com/2008/09/h...counts-in.html
==============

 

Our Dynamics AX database is getting bigger - that means business is active and that is usually a good thing :) We use SQLServer as the back-end database server. Here is a trick that will count all of the rows in all of the Axapta tables in about 1 second. This trick will only run on SQLServer (all versions 2000 - 2008).

Here is a query that will return the row counts of every table in your Dynamics AX database.

<blockquote> USE Axapta
go

<font face="Courier">

select so.name as Table_Name
      ,rows
  from sysindexes si
         inner join
       sysobjects so
         on si.id = so.id
where so.type = 'u'
   and indid