Primary Key

A primary key is a column or combination of columns in a table that contain values that uniquely identify each row in a table, a primary key column cannot have NULL values.

For instance user wants to select primary key for base table LINEITEM and columns L_ORDERKEY , L_PARTKEY.

To create primary key in uArrow:
Click on tick the box for columns L_ORDERKEY , L_PARTKEY columns for primary key.

Below is the window with selected primary key columns.

Menu