Post reply

Looking for script to list all indexes in database, write to table

  • March 3, 2006 at 8:56 am

    #171349

    I was looking for a script that would enumerate a database for all indexes and associated information and write all that information to a permenant table.

     

    Appreciate replies

  • March 3, 2006 at 9:51 am

    #624658

    I haven't got one to hand but it's all in the sysindexes table. Probably wouldn't take long to write one.

  • March 3, 2006 at 2:22 pm

    #624740

    There is one in the script section here -> just lOOk


    _/_/_/ paramind _/_/_/

  • March 4, 2006 at 12:22 am

    #624765

    Here is the select statement, i don't know whether it is useful for you or not.

    use

    select a.name table_name,xtype,b.name Index_name from sysobjects a,sysindexes b

    where a.xtype='U' and a.id=b.id order by a.name

    Ramaa

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply