Administering Full-Text Features Using Stored Procedures and Scalar Functions
Administering full-text features using stored procedures and scalar functions is described through examples provided in these topics:
- Enabling Others to Issue Full-Text Queries
- Performing Investigation and Clean-up Tasks for Full-Text Catalogs
- Performing Infrequent Tasks
The examples in these topics use two fictitious tables, writers and books, in the pubs database. This table shows the writers table and the columns that are candidates for full-text indexing, specifically the varchar data type.
Column name |
Data type |
Enable full-text features? |
|---|---|---|
| writer_name | char(40) | No |
| citizenship | char(40) | No |
| organization | varchar(100) | Yes |
| royalties_ytd | decimal(7,2) | No |
| Royalyties_lifetime | decimal(7,2) | No |
| Bio | varchar(500) | Yes |
| writer_id | integer (with a unique value enforced by the writer_id_index index) | No |
| last_changed | timestamp | No |
This table shows the books table and the columns that are candidates for full-text indexing, specifically the varchar and text data types.
Column name |
Data type |
Enable full-text features? |
|---|---|---|
| writer_name | char(40) | No |
| Title | varchar(120) | Yes |
| Size | smallint | No |
| pub_date | datetime | No |
| the_words | text | Yes |
| Abstract | varchar(500) | Yes |
| isbn | char(15) (with a unique value enforced by the isbn_index index) | No |
| last_changed | timestamp | No |
For more information about both querying and indexing, see Example of Combining Full-Text Administration and Full-Text Query.