Index Problem

• Manish_

  Ten Centuries

  Points: 1070

  More actions

  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

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  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]

• Manish_

  Ten Centuries

  Points: 1070

  More actions

  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