Assigning Primary Keys in an Onboarded Schema

If you have a Data Source without Primary Keys and you want to be able to create Foreign Key relationships, you can assign Primary Keys in the Schema. Follow the instructions below to edit a Schema and assign Primary Keys. For instructions on creating Foreign Keys, see Creating or Changing Foreign Keys.

  1. In the Anzo application, expand the Onboard menu and click Structured Data. Anzo displays the Data Sources screen, which lists any existing Data Sources. For example:

  2. Click the Schemas tab to view the list of Schemas. For example:

  3. Click the Schema for which you want to assign Primary Keys. Anzo displays the Tables tab. Click a row on the left side of the screen to display details on the right side of the screen. For example:

  4. In the table details, find the column that you want to label as the Primary Key. Hover your pointer over the column name to display additional icons. Edit and Delete icons replace the data type under the column name. For example:

  5. Click the edit icon (). The Edit dialog box is displayed. For example:

  6. On the Edit screen, select the Primary Key checkbox. Then click Save to save the change. The column is now the Primary Key for the table, and a key icon is displayed next to the column name. For example:

Repeat the steps above to assign primary keys for additional Schema tables.

Related Topics