I have a table test with one column (id int).
create table test (id int)
Then I created an index on this table column
create index tst_ndx on test (id)
Now I want to change the table column type to varchar.
alter table test alter column id varchar(10)
But it gave me the error
ALTER TABLE ALTER COLUMN id failed because INDEX tst_ndx accesses this column.
Is there anyway I can change the column datatype with out dropping and recreating this index.
Any help on this will be highly appreciated.
Thanks in advance