Hi folks

I want to be able to drop all the indexes in a database.

I gather I need to use sysobjects & sysindexes tables to get the index names but am not too sure how to go about doing this in Transact-SQL.

Would appreciate any pointers...

Regards

Kal