Do I need to mention primary key for each table

Question

Hey,

I am bit confused about primary key and constraints in database. Is there any rule that for each table I need to use primary key or foreign key?

Answer 1

Hi Pritha,

First, there is no hard and fast rule to add constraint in your table But we use constraint in our table to reduce data repetition and redundancy in our table.

And if you want to fetch one particular data that time primary key will help you to get that row only.

I hope, this will help you out

Thank you,