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