Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Indexes

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-05-29 : 09:26:19
showry writes "Can i get list of indexes with the information like tablename, columnname, indexname, type of index(clustered or non - clustered) on a database with a system procedure?"

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2002-05-29 : 10:04:08
Try sp_indexes
Go to Top of Page
   

- Advertisement -