This example returns all index information from the Employees table of the
Northwind database on the LONDON1 database server.

EXEC sp_indexes @table_server = 'LONDON1',

@table_name = 'Employees',
@table_catalog = 'Northwind',
@is_unique = 0

Regards,
Santhosh

> ----------
> From: Coskan Gundogar[SMTP:[Email Address Removed] Sent: Wednesday, May 28, 2003 6:11 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] For additional commands, e-mail: mssqldba-[Email Address Removed]
MS Sql Server LazyDBA home page