Creates a new text filter.

Syntax

---

CREATE TEXT FILTER <Name>
TYPE <FilterType>
MODULE <ExternalModuleName>
[DESCRIPTION <Description>]

Usage

---

Use this statement to create a new text filter. A text filter associates a particular filter name with a text filter module that will be used to filter the text prior to the text being indexed by ElevateDB and added to a text index. The referenced external text filter module must already be created and available to the current session. Please see the Text Indexing topic for more information.

Examples

---

-- The following statement creates a text filter for HTML

CREATE TEXT FILTER "HTML"
TYPE 'HTML'
MODULE "HTMLFilter"
DESCRIPTION 'Filters HTML'

Required Privileges

---

The current user must be granted the system-defined Administrators role in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations

---

This statement deviates from the SQL 2003 standard in the following ways: