Administering full-text features using stored procedures and scalar functions is described through examples provided in these topics:
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.