Assign Key Columns

By default the database schema is analyzed to determine which columns are primary key columns. Primary key columns are used to associate indexed words to specific records. If indexing a table that does not have a primary key constraint defined or a view, a primary key column must be manually defined.

Note

Key(s) must also be defined for those custom pages that are based on a view or a table with no primary key. Refer to Page Design Guidelines for more information.

To define a column as a primary key:

1. Select Admin > WebApps from the Navigation pane.

2. Click Pages for a WEB APP NAME.

3. Click the Column Properties icon for the page with the key column.

4. Click Vertical View for the key column.

5. Click Edit.

View the field descriptions for the Page Columns page's Vertical View

1. Click the Advanced Properties tab.

2. Click the Key check box to mark it as the primary key.

3. Click Save.