decoding system table ids

• ksexton

  SSCrazy

  Points: 2790

  More actions

  April 12, 2002 at 6:33 am

  #58191

  I am qucikly learning how to decode the id numbers int he system tables using:

  object_name(id)

  user_name(uid)

  Is there a reference sheet for all of these useful "decodes".

  Example: I am trying to query the sysindexes table to see which are CLUSTERED indexes.

  Kevin

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  April 12, 2002 at 6:52 am

  #427101

  You might want to look at objectproperty and databaseproperty functions.

  Andy

  Andy
  Connect with me on LinkedIn