25112
asked on
not able to rearrange the columns if it had the ALTER TABLE INDEX
when a table has the below kind of index (with a WHERE), then it does not allow me to rearrange the order of columns, unless i drop the index first. is there a way to disable this need?
CREATE UNIQUE NONCLUSTERED INDEX ix_abc
ON tablename (Columname) WHERE Columname IS NOT NULL
CREATE UNIQUE NONCLUSTERED INDEX ix_abc
ON tablename (Columname) WHERE Columname IS NOT NULL
why do you care what order the columns are in?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.