fulltext catalog icon Full Text Catalog: AW2008FullTextCatalog

Properties

Property Value
Name AW2008FullTextCatalog
ID 5
Owner dbo
Catalog Path
Unique Key Count 2105
Item Count 30
Index Size 0
Default true
Accent Sensitive true

Columns

Schema Name Object Name Index Name Column Extension Column Language
Production ProductReview PK_ProductReview_ProductReviewID Comments English
Production Document PK_Document_DocumentNode DocumentSummary English
Production Document PK_Document_DocumentNode Document FileExtension English
HumanResources JobCandidate PK_JobCandidate_JobCandidateID Resume English

Indexes

Schema Name Object Name Index Name Enabled Change Tracking State Crawl Completed Crawl Type Filegroup
Production ProductReview PK_ProductReview_ProductReviewID true AUTO true UPDATE CRAWL PRIMARY
Production Document PK_Document_DocumentNode true AUTO true UPDATE CRAWL PRIMARY
HumanResources JobCandidate PK_JobCandidate_JobCandidateID true AUTO true UPDATE CRAWL PRIMARY

Permissions

Permissions for: duser

Permission Grantor Grant With Grant Option Deny
ALTER
CONTROL
REFERENCES dbo true
TAKE OWNERSHIP
VIEW DEFINITION

Permissions for: public

Permission Grantor Grant With Grant Option Deny
ALTER
CONTROL
REFERENCES
TAKE OWNERSHIP dbo true
VIEW DEFINITION

SQL

Script
CREATE FULLTEXT CATALOG [AW2008FullTextCatalog]WITH ACCENT_SENSITIVITY = ON AS DEFAULT AUTHORIZATION [dbo]

See also

List of Full Text Catalogs