Answer the question
In order to leave comments, you need to log in
How to create a full text index for a non SCHEMABOUND view?
I need to enable full-text search on the view, but it was created without SCHEMABINDING and does not allow me to create an index. I cannot recreate this view with SCHEMABINDING because it depends on tables that are also not SCHEMABOUND and cannot be, because some of their fields depend on tables from another database.
Is it somehow possible to create an index on the view I need without SCHEMABINDING?
Answer the question
In order to leave comments, you need to log in
The documentation clearly says "the name of the table or indexed view".
but maybe there are waysCreate a separate table for searching and place data there with triggers.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question