Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Creating Full Text index on temporary table

When I create a full text index on a temporary table #Table in a query? I got Invalid name object #Table. Is creating full text index possible in sql server?

like image 861
Sumit Kadam Avatar asked Jul 13 '26 03:07

Sumit Kadam


1 Answers

According to the documentation, no it is not possible:

A full-text index must be defined on a base table; it cannot be defined on a view, system table, or temporary table.

This should be clarified to point out that since the version that documentation was written for, indexed views were added to SQL Server, and documentation there states that:

one full-text index is allowed per table or indexed view

like image 122
AHiggins Avatar answered Jul 14 '26 17:07

AHiggins



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!