A
A
akrvch2021-08-04 14:29:30
SQL Server
akrvch, 2021-08-04 14:29:30

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

1 answer(s)
K
Konstantin Tsvetkov, 2021-08-04
@tsklab

The documentation clearly says "the name of the table or indexed view".

but maybe there are ways
Create a separate table for searching and place data there with triggers.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question