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