Statistics still exist after dropping it

• EasyBoy

  SSCertifiable

  Points: 5301

  More actions

  April 4, 2013 at 10:39 pm

  #276097

  I have dropped the statistics but after dropping it still exist.

  Does anyone know how can i delete that?

  Actually i need to alter the column that depend upon statistics. But somehow after deleting it still exists.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  April 5, 2013 at 1:48 am

  #1603826

  How did you drop the statistic? How are you seeing that it's still there?

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• EasyBoy

  SSCertifiable

  Points: 5301

  More actions

  April 5, 2013 at 4:06 am

  #1603843

  I have dropped the statistics using script

  drop statistics table_name.statistics_name.

  And check again using

  sp_helpstats table_name.

  Anyway this problem has been resolved.

  Thanks for your time.

• DiverKas

  SSCrazy

  Points: 2049

  More actions

  April 5, 2013 at 7:16 am

  #1603889

  EasyBoy (4/5/2013)

  ---

  I have dropped the statistics using script

  drop statistics table_name.statistics_name.

  And check again using

  sp_helpstats table_name.

  Anyway this problem has been resolved.

  Thanks for your time.

  Wait! What? LOL, what was the solution, just in case someone else has a similiar issue?

  Come on Paul harvey, give me the rest of the story!