Databasetable with indexes (SQL Server 2000)

2 
EXEC sp_helpindex 'MyTable';

That will output all the index details for MyTable, substitute your table name(s) as needed.