Results 1 to 4 of 4

Thread: how to find if index key is ASC or DESC from system tables?

  1. 04-29-2003, 07:14 PM #1
    agoyal
    agoyal is offline Registered User
    Join Date
    Apr 2003
    Posts
    4

    Question how to find if index key is ASC or DESC from system tables?

    There is a index: CustomerInfo_1
    with keys: customerId, EnteryDate DESC
    I could not find where the order of index key (i.e. whether the key is ascending or descending) is stored?
    I tried system tables such as sysindexes and sysindexkeys tables. But could not find it.
    Any help in this regard will be truly appreciated.

    Thank you.
    Regards,
    Anuj Goyal
    Reply With Quote Reply With Quote
  2. 04-30-2003, 07:54 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Check it in em -> design table.
    Reply With Quote Reply With Quote
  3. 04-30-2003, 09:36 AM #3
    Ads
    Ads is offline Registered User
    Join Date
    Oct 2002
    Posts
    123
    You can see the ASC/DESC value of a index in EM only in sql 2000...sql 7.0 doesnt allow that.
    Reply With Quote Reply With Quote
  4. 04-30-2003, 10:25 AM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Since sql7 doesn't let you specify index key order, always in asc order.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules