Full text catalog properties
| name | value |
|---|
| name | AW2008FullTextCatalog |
| filegroup | |
| full text index size | 0 |
| has full text indexed tables | True |
| accent sensitive | True |
| default | True |
| item count | 30 |
| owner | dbo |
| population completion age | 00:06:39.0030000 |
| population completion date | 9/15/2011 7:31:34 PM |
| population status | Idle |
| root path | |
| unique key count | 2105 |
Indexes in catalog
Dependency graph
Objects that depend on AW2008FullTextCatalog
| name | object type | database | server | level |
|---|
| JobCandidate | full text index | AdventureWorks2008 | SPRING\KATMAI | 1 |
| Document | full text index | AdventureWorks2008 | SPRING\KATMAI | 1 |
| ProductReview | full text index | AdventureWorks2008 | SPRING\KATMAI | 1 |
Code
CREATE FULLTEXT CATALOG [AW2008FullTextCatalog]WITH ACCENT_SENSITIVITY = ON
AS DEFAULT
AUTHORIZATION [dbo]