Full Text Catalog: JohnCatalog Full Text Catalog: JohnCatalog| Property | Value |
|---|---|
| Name | JohnCatalog |
| ID | 6 |
| Owner | JohnBlack |
| Catalog Path | |
| Unique Key Count | 648 |
| Item Count | 290 |
| Index Size | 0 |
| Default |
|
| Accent Sensitive |
|
| Schema Name | Object Name | Index Name | Column | Extension Column | Language |
|---|---|---|---|---|---|
| Sales | mobiFT | PK__mobiFT__3213E83F642DD430 | zjebka | English | |
| dbo | vMobiEmployee | PK_vMobiEmployee_NationalIDNumber | NationalIDNumber | English | |
| dbo | vMobiEmployee | PK_vMobiEmployee_NationalIDNumber | JobTitle | English |
| Schema Name | Object Name | Index Name | Enabled | Change Tracking State | Crawl Completed | Crawl Type | Filegroup |
|---|---|---|---|---|---|---|---|
| Sales | mobiFT | PK__mobiFT__3213E83F642DD430 |
|
MANUAL |
|
FULL CRAWL | PRIMARY |
| dbo | vMobiEmployee | PK_vMobiEmployee_NationalIDNumber |
|
AUTO |
|
UPDATE CRAWL | PRIMARY |
| Script |
|---|
| CREATE FULLTEXT CATALOG [JohnCatalog]WITH ACCENT_SENSITIVITY = ON
AUTHORIZATION [JohnBlack]
|