Full text index properties
| name | value |
|---|
| name | Full text index on [Production].[Document] |
| table | Document |
| 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_Document_DocumentNode |
Indexed columns
| column | language |
|---|
| Document | English |
| DocumentSummary | English |
Dependency graph
Objects that Full text index on [Production].[Document] depends on
Code
CREATE FULLTEXT INDEX ON [Production].[Document](
[Document] TYPE COLUMN [FileExtension] LANGUAGE [English],
[DocumentSummary] LANGUAGE [English])
KEY INDEX [PK_Document_DocumentNode]ON ([AW2008FullTextCatalog], FILEGROUP [PRIMARY])
WITH (CHANGE_TRACKING = AUTO, STOPLIST = SYSTEM)