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