Verify Primary Key in Incorta
I’m not sure what is the primary key of a table, for example, this Orderitems table. Here is how I verified. My assumption is that an order can have multiple items and an item will be listed once an order.
By grouping Orderitems with orderNumber and productCode, we should get one row per group. If we got more than one row, we can conclude that the combination of orderNumber and productCode is not unique.
The result shows that no data returned. This verifies my assumption is true.
Comments
Post a Comment