Structure

---

CREATE TABLE "TextFilters"
(
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"Description" CLOB COLLATE "ANSI",
"Type" VARCHAR(15) COLLATE "ANSI_CI",
"ModuleName" VARCHAR(255) COLLATE "ANSI_CI",
"CreateSQL" CLOB COLLATE "ANSI_CI",
"DropSQL" CLOB COLLATE "ANSI_CI"
)

CREATE INDEX "Name" ON "TextFilters"
("Name")

Description

---

This table contains the defined text filters in an ElevateDB configuration. The text filters are used by the full-text indexing functionality in ElevateDB to filter out text before it is indexed. Text filters are defined with a specific type, such as 'html' or 'rtf'. In addition, each text index defined for a given table can specify a filter column. The values in this filter column are used by the text index in conjunction with the type assigned to each text filter to determine which text filter to use for filtering the text before it is indexed. You can find out more about text indexing in the Text Indexing.

Related DDL Statements

---