Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2004
    Posts
    61

    Unanswered: all indexes in DB

    Hi all,

    I want to know all indexes in database.
    What do I do to get them?

    Thanks in advanced,
    Thi Nguyen

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    the sysindexes-table might get your started. From BOL: "Contains one row for each index and table in the database. This table is stored in each database".

  3. #3
    Join Date
    Jul 2004
    Posts
    61
    No, I want to know all names of indexes in database.

  4. #4
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    Quote Originally Posted by thinguyen
    No, I want to know all names of indexes in database.
    select name from sysindexes

  5. #5
    Join Date
    Jul 2004
    Posts
    61
    that is good.
    I just want to get user defined index names, not all names.

    Thanks
    Thi Nguyen

Posting Permissions

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