[dba-SQLServer] Syntax to add field to index

I looked into this on your behalf and have not come up with anything useful
(c.f. ALTER INDEX etc.).

My suggestion thereore is to drop the index(es) and create from scratch.
This syntax is trivial and by now I'm sure that you know it by rote. You
have wrestled numeruous pigs in the mud in this app, so I won't bother you
with redundant ops.

There (IMO) is no advantage to be gained by any ALTER INDEX variation.
Better to DROP INDEX then recreate it according to your new requirements.

A.

On Thu, Jun 11, 2009 at 1:46 PM, jwcolby <jwcolby at colbyconsulting.com>wrote:

> I need to create an index on a table, then use the index to update another
> field, then add that
> other field to the index.  Is there a syntax to add a field to an existing
> index or is it just drop
> / create index?
>
> I create indexes in stored procedures, but I have never added another field
> to an existing index.
>
>