Keys
The Keys tab of the SQL Metadata Tool allows you to add one or more columns as keys to the SQL table.
- Current schema
- The schema containing the keys. The schema is selected in the Schemas tab.
- Current table
- The table containing the keys. The table is selected in the Tables tab.
- Primary keys
- The column(s) that contain primary keys, and are displayed with a green background. Click Remove to remove the column(s).
- Keys
- The column(s) that contain keys, and are displayed with a blue background. Click Remove to remove the key or Make primary to promote the key to a primary key.
- Add key
- A drop-down list containing the columns in the table. Click Add key to add one or more, or all columns as keys.