Home SQL Server Commands
 

ALTER FULLTEXT CATALOG

Create a full-text catalog for the database.

Syntax
      ALTER FULLTEXT CATALOG catalog 
         {REBUILD [ WITH ACCENT_SENSITIVITY = {ON | OFF} ]
         | REORGANIZE
         | AS DEFAULT 
         }
Key:
    catalog    Name of the catalog to create
    AS DEFAULT Specify that this is the default catalog.

Example

ALTER 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
CREATE FULLTEXT CATALOG
DROP FULLTEXT CATALOG

Equivalent Oracle commands:

Oracle Text / InterMedia / ConText



Back to the Top

Simon Sheppard
SS64.com