Full text index properties
| name | value |
|---|
| name | Full text index on [Production].[ProductReview] |
| table | ProductReview |
| catalog | AW2008FullTextCatalog |
| change tracking | Automatic |
| documents processed | 0 |
| enabled | True |
| item count | 4 |
| number of failures | 0 |
| pending changes | 0 |
| population status | None |
| unique index name | PK_ProductReview_ProductReviewID |
Indexed columns
| column | language |
|---|
| Comments | English |
Dependency graph
Objects that Full text index on [Production].[ProductReview] depends on
Code
CREATE FULLTEXT INDEX ON [Production].[ProductReview](
[Comments] LANGUAGE [English])
KEY INDEX [PK_ProductReview_ProductReviewID]ON ([AW2008FullTextCatalog], FILEGROUP [PRIMARY])
WITH (CHANGE_TRACKING = AUTO, STOPLIST = SYSTEM)