Specify the new name for the index, primary key, or foreign key.
When you rename the underlying index for a foreign or primary key, the corresponding RI constraint name for the index is not
changed. However, the foreign key role name, if applicable, is the same as the index name and is changed. Use the ALTER TABLE
statement to rename the RI constraint name, if necessary.
Specify whether the index should be changed to CLUSTERED or NONCLUSTERED. Only one index on a table can be clustered.
Use this clause to rebuild an index, instead of dropping and recreating it.