CREATE FULLTEXT CATALOG

Create a full-text catalog for the database.

Syntax
      CREATE FULLTEXT CATALOG catalog
         [ON FILEGROUP filegroup ]
            [IN PATH 'rootpath']
               [WITH ACCENT_SENSITIVITY = {ON|OFF}]
                  [AS DEFAULT] [AUTHORIZATION owner ]

Key:
    catalog    Name of the catalog to create
    rootpath   The local root directory for the catalog.
    AS DEFAULT Specify that this is the default catalog.

After creating a catalog, one or more full-text indexes may be associated with it.

Example

CREATE FULLTEXT CATALOG MyCatalog AS DEFAULT; 

"The greatest Christmas gift can't be purchased in a store, ordered from a catalog, wrapped in a pretty package with a fancy bow ... but it can be seen in the eyes of a child, heard in the words of kindness & felt in the embrace of a friend" ~ anon

Related commands:

CREATE FULLTEXT INDEX
ALTER FULLTEXT CATALOG
DROP FULLTEXT CATALOG
Equivalent Oracle commands: Oracle Text / InterMedia / ConText


© Copyright SS64.com 1999-2014
Some rights reserved