title: How to a remove all database indexes from a SQL server database
body: <p>I am about to write a script to add new indexes to a database, I wish that script to work regardless of the current indexes the database has.</p>
  
  <p>Therefore the first step in the script should be to remove all the current indexes.  (I could just as easily run .net code, but I think TSQL will be less painful for this type of thing)</p>
  
  <p>(This is for use in development for small databases, so I don’t mind if it is not the quickest way of managing indexes, this needs to work for SqlServer 2005 and SqlServer 2008)</p>