if if i have a table like below
EmpID EmpName City
1 A H
2 B T
3 C P
On EmpName column we have an already existing full text index, we have to create one more full text index on column city, then what we have to do, we have to delete the previous one and create the new one or sql server will not allow or we can carry out with other?