--- title: "Assign Key Columns" slug: "assign-key-columns" updated: 2024-08-20T18:02:44Z published: 2024-08-20T18:02:44Z canonical: "skthelp.syniti.com/assign-key-columns" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # 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] > **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](/v1/docs/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*](/v1/docs/page-columns-h#page-columns-v) 1. Click the **Advanced Properties** tab. 2. Click the **Key** check box to mark it as the primary key. 3. Click **Save**.