<div>
In summary:<br />
<br />
*) capture current info using EXEC sp_helpindex 'tablename'<br />
*) drop non-clustered indexes<br />
*) drop clustered index (if any)<br />
*) recreate non-clustered indexes<br />
*) recreate clustered index (if any)<br />
<br />
<br />
<br />

</div>


In summary:

*) capture current info using EXEC sp_helpindex 'tablename'
*) drop non-clustered indexes
*) drop clustered index (if any)
*) recreate non-clustered indexes
*) recreate clustered index (if any)





<div>
<div class="content wysiwyg-content">
is there a way to drop all indexes (PK + indexes) on a table? is there a stored procedures? i don't know the names of the indexes... i want to use it in my program to clear a table of the indexes and rebuild new indexes...
</div>
</div>


is there a way to drop all indexes (PK + indexes) on a table? is there a stored procedures? i don't know the names of the indexes... i want to use it in my program to clear a table of the indexes and rebuild new indexes...

Dropping ALL indexes (incl PK) on a table

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.