CODEWITHSUNDEEP
indexingsql-server-2000full-text-search
saurabh
saurabh

Reputation:

Can I use full text indexing on a view?

I am using SQL Server 2000 and I am using full text indexing on a table. Can I use full text indexing on a view of this table? If yes, then how can I use? If no, then what should I do?

Actually, I am doing refinement of the results obtained from a table and for this refinement I am using a view of this table...

Upvotes: 2

Views: 1661

Answers (2)

Mitch Wheat
Mitch Wheat

Reputation: 300827

No, you cannot use full text indexing on the view of a table.

You can apparently create one on an indexed view though.

See also: Creating an Indexed View

Upvotes: 3

Jalpesh Vadgama
Jalpesh Vadgama

Reputation: 14266

I think you can create full text index on view. Here is the idea for the creating a view.

https://stackoverflow.com/questions/263071?sort=votes

Upvotes: 0

Related Questions