Return
-
Title
Cannot drop index ... because it enforces the full-text key for table or indexed view ... -
Description
While trying to synchronize a Full Text index table to another using ApexSQL Diff an error stating "Cannot drop index" appears.
-
Cause
Some constraints due to index may cause the synchronization to fail. -
Resolution
Before comparing go to Options> Table Attributes and check all Index-related options under Table Attributes, like:
- Asc/Desc for Index Columns
- Full Text Indexes
- Indexes
- Index Names
- Secondary Index Attributes
