Export (0) Print
Expand All

Full-text Querying SQL Server Data

SQL Server 2000

Digital information is stored in both database columns and in the file system as unstructured data, primarily text. Some text data is stored in database character-type columns as well. For example, in Microsoft® SQL Server™, such data can be stored in database columns with the char, varchar, text, ntext, nchar, or nvarchar data types.

Consequently, a method for retrieving this text data from the database is needed. Relational database management systems traditionally have had limited capabilities for finding patterns in textual data. For example, a system may be able to retrieve text based on pattern matching, but cannot handle searches that look up words and phrases in close proximity to one another.

Previously, corporate users of relational database management systems had to buy expensive third-party offerings to retrieve or query data stored in these character-based database columns. These solutions typically involved a two-step process:

  1. Pull data out of the database through a bridge or gateway.

  2. Store the data as character-based operating-system files so that full-text indexing can be applied.

Using this two-step process meant that there was no seamless way for combining a full-text query with a regular, structured relational query. SQL Server solves this problem by allowing full-text queries to be issued against plain character-based data in SQL Server tables, including words and phrases, or multiple forms of a word or phrase.

To enable a database for full-text indexing

Enterprise Manager

Transact-SQL

To enable a table for full-text indexing

Enterprise Manager

Transact-SQL

To enable a column for full-text indexing

Enterprise Manager

Transact-SQL

To edit a full-text index on a table

Enterprise Manager

Transact-SQL

To remove full-text indexing from a table

Enterprise Manager

Transact-SQL

To create a full-text catalog

Enterprise Manager

Transact-SQL

To rebuild a full-text catalog

Enterprise Manager

Transact-SQL

To rebuild all full-text catalogs in a database

Enterprise Manager

Transact-SQL

To start and stop a full or incremental population of a full-text index

Enterprise Manager

Transact-SQL

To check the status, tables, and schedules of a full-text catalog

Enterprise Manager

To change or create a new schedule for a full-text catalog

Enterprise Manager

To remove a full-text catalog from a database

Enterprise Manager

Transact-SQL

To remove all full-text catalogs in a database

Enterprise Manager

Transact-SQL

To clean up the full-text catalogs on a server

Enterprise Manager

Transact-SQL

To repopulate all full-text catalogs for a database

Enterprise Manager

Transact-SQL

Show:
© 2014 Microsoft