Results 1 to 3 of 3

Thread: index list

  1. #1
    Join Date
    Feb 2014
    Posts
    42
    Provided Answers: 1

    Unanswered: index list

    how to get the list of indexes from the user defined database, i need to get the count and list as well

  2. #2
    Join Date
    Jan 2012
    Location
    Lisbon
    Posts
    115
    Provided Answers: 1
    Hi there,

    try this one:

    use [dbname]
    go

    select i.name
    from sysobjects o , sysindexes i
    where i.id=o.id
    and o.type='U'
    and i.indid > 0
    and i.indid < 255
    go

  3. #3
    Join Date
    Feb 2014
    Posts
    42
    Provided Answers: 1
    Thanks for that ,its working

Posting Permissions

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