Script for getting the statistics of a table

• babuganesh2000

  Hall of Fame

  Points: 3123

  More actions

  December 28, 2004 at 4:52 pm

  #361799

  Hi Everyone,

  I need a script to list all the user tables and its corresponding no.of rows inserted,deleted,updated individually.

  Can anyone help me out giving me a clue.

  select o.name,i.rowmodctr

  FROM SYSOBJECTS o

    JOIN SYSINDEXES i

       ON o.id = i.id

      and o.xtype = 'U'

      and o.name  = 'daily_master'

  The table name I have specified in this query has a column date_created which is defaulted to getdate(). Totally there are about 50,000 rows got inserted to the table. But the output of the query seems to be weird.

  Basically, I wanted to run a query to get the statistical information of a particular table.

  Thanks in advance.

  Thanks,

  Ganesh

   

   

   

• THANG HOANG

  Say Hey Kid

  Points: 662

  More actions

  December 31, 2004 at 9:34 am

  #535517

  My guess is you're probably referring to the multiple rows result set.

  If so, you want to limit the query by index id type.

  Try append this clause to the query

  and i.indid in (0,1)