[dba-SQLServer] Syntax to add field to index

jwcolby jwcolby at colbyconsulting.com
Thu Jun 11 12:46:13 CDT 2009


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.

-- 
John W. Colby
www.ColbyConsulting.com



More information about the dba-SQLServer mailing list