SQLTeam.com | Weblogs | Forums

Can we create more than one full text index on different column in a table?


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?


A full text index is created on a table, not a column. So, no, you cannot have more than one per table.