Recreating Indexes Dynamically

[mssqlforum]

How to get all the index properties like unique, clustered of an index.

I need to recreate all the indexes in a table dynamically
1) need to get the list of indexes
2) drop them
3) change some properties and recreate the indexes, to do this I need to know the columns, uniqueness, clusteredness in step 1 above. How can I get to that?

In oracle we can depend on tables like index_columns, index_constraints....

thx

[rmiao]

Try sp_helpindex.

[MAK]

Check books online for sysindexes system table.