You create a data table on your database that stores the link between the word and bib record.
You complete the steps in this task using your SQL query tool. Make sure to watch for errors as you run queries.
To create an index table
1 | Use an sp_help command on an existing table to determine the design or template you want for your new table. |
For example, executing sp_help on the titlkw_word table produces this output:
Name Owner Type
titlKW_word dbo user table
Data_located_on_segment When_created
----------------------- ------------
Column_name Type Length Prec Scale Nulls
2 | Use an SQL command to create the index table. |
For example, run this command:
create table vtitleKW_word(bib# int, word# int)
© 1998-2017 Sirsi Corporation