Post reply

Index Problem

  • August 18, 2004 at 10:11 pm

    #86328

    Dear Experts

    I  had created an index on of my table in SQLSERVER 2000 !and after some time i had added a field on the table for which i had created index now i want to reindex the table ,but now i don;t know the name of the indextable which i had made,I tried to search it on the ENTERPRISE MANAGER but i can;t get !

    Can any one help me to find out the list of all the

    TABLE NAME / and the INDEX

     

    - Manish

  • August 19, 2004 at 1:12 am

    #519703

    I'm not sure if I understand your question correct but this might help:

    Select o.name as tablename, i.name as Indexname from sysobjects o join sysindexes i

    ON o.id =i.id

     

    M

    [font="Verdana"]Markus Bohse[/font]

  • August 19, 2004 at 6:35 am

    #519749

    Thanks Mark

    Its that only for which i was searching !

    Thanks you  so much

    Have a nice time

    - Manish

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

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