Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2007
    Posts
    64

    Thumbs down Unanswered: FETCH index details of a Table

    I Use the below QUERY to fetch the index details of a table from SQL Server 2000 database .

    EXEC sp_helpindex 'mytable'
    Is there any alternative for the above query .
    Because the above query is not fetching some indexes in some version of SQL Server database .

    I am trying the above query against SQL Server 2000,2005 and SQL Server 7 versions .

  2. #2
    Join Date
    Aug 2007
    Posts
    64

    Lightbulb FETCH indexes from the Database

    I want to know the INDEXes details of a particular table . I tried executing the below Query .

    sp_helpindex 'TableName'
    The above query is giving onle few INDEXES .
    It is returning only 4 indexes out of 9 present for that particular table .

    Please suggest me the solution to get all the indexes

  3. #3
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    How do you know there are nine indexes? Is it possible you are confusing indexes and constraints?

    What version of SQL Server are you using - including service pack?

    -- This is all just a Figment of my Imagination --

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Threads merged.

    sushma007 - no need for two threads for what is ostensibly the same question.

    Ta

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    My guess on this is that you've confused indicies with several flavors of pseudo-indicies that have similar structure to an index, but are not indicies. SQL Server creates index like structures for statistics, etc. but those are not indicies.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •