Query To Find Statistics For Specific Table

   
  /**** All Statistics for particular table*******/
          Use  database_name
          GO
          Select object_name(object_id) as TABLE_NAME ,name as STATS_NAME,
          Case auto_created  when 0
          Then  'auto_created' Else 'User_Created' end as CREATED_BY
          from SYS.STATS where object_name(object_id) = 'Table_Name'
         
/*****************************************/

          Example:

          Create database A
          GO
          use A
          GO
          Create table a(a int , b int)
          GO
          insert into a values (1,1)
          CREATE STATISTICS [stats_a_a] ON [dbo].[a]([a])
          CREATE STATISTICS [stats_a_b] ON [dbo].[a]([b])
          GO
          ---- All statistics on pirticular table
          Select object_name(object_id) as TABLE_NAME ,name as STATS_NAME,
          Case auto_created  when 0
          Then  'auto_created' Else 'User_Created' end as CREATED_BY
          from SYS.STATS where object_name(object_id) = 'a'

Output:

1 comment: