sp_mshelpindex 'table_name'

-----Original Message-----
From: Coskan Gundogar [mailto:[Email Address Removed] Wednesday, May 28, 2003 1:42 PM
To: LazyDBA.com Discussion
Subject: view indexes


is there a way to view all indexes for a table/ for a database ?

i want to get the names of all indexes for db maintenance


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page