() — thirdparty Sybase/SQL_Server

  1                       Version 4.0 -- 1/15/89            sp_helpindex
  ______________________________________________________________________

  NAME:  sp_helpindex

  FUNCTION:
       Reports index information on a table.

  SYNTAX:
       sp_helpindex tabname

  EXAMPLES:
       sp_helpindex sysobjects

       Reports on the types of indexes on the sysobjects table:







  sp_helpindex            Version 4.0 -- 1/15/89                       2
  ______________________________________________________________________

          index_name           index_description                         index_keys
          --------------       ------------------------------------      ----------
          titleidind           clustered, unique located on default      title_id
          titleind             nonclustered located on default           title

          (2 rows affected, return status = 0)

  PARAMETERS:
       tabname -  is the name of a table in the current database.

  COMMENTS:

       o Executing sp_helpindex lists the indexes on a table, if any.

  MESSAGES:
       The name you gave for the tabname parameter does not exist in the
           current database.


  3                       Version 4.0 -- 1/15/89            sp_helpindex
  ______________________________________________________________________
       The table you named has no indexes.
       The name you gave for the tabname parameter includes  a  database
           reference.   Name  references  must  be  local to the current
           database.

  PERMISSIONS:
       Execute permission to public.

  TABLES USED:
       #spindtab, master.dbo.spt_values, sysindexes

  SEE ALSO:
       sp_help, sp_helpkey, CREATE INDEX, DROP INDEX, UPDATE STATISTICS
Museum
