Post reply

Statistics still exist after dropping it

  • 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.

  • 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

  • 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.

  • 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!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply