The following example drops and re-creates an existing index on the ProductID column of the Production.WorkOrder table in the AdventureWorks2012 database by using the DROP_EXISTING option. The options FILLFACTOR and PAD_INDEX are also set.