When you alter the attributes of a column and an index has been defined for that column, the values in the altered column continue to have the index defined for them. If you drop a column with the ...

Any column that is not modified retains its original values, except in certain queries using the CASE expression. See CASE expression for a description of CASE expressions. To add, drop, or modify a ...