开发者

Using SQL Server Fulltext Search with a Union View

I have a view which combines two tables via UNION ALL. The view is also schemabound, if that matters (WITH SCHEMABINDING).

Is it possible to enable fulltext search on this view? I understand that Fulltext Search requires a uni开发者_开发百科que index, but I can't create it because of UNION.

Is there another way to make Fulltext Search work on the view?


You could always fulltext search on the component table, and then use other data from that table (id) to get the row back out of the UNION. Unless, of course, what you're fulltext searching on is composited out of the component rows, in which case this won't help you.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜