Using Email address as primary key in SQL Server

Hi George616,

It is better if you use an integer instead of email as primary key. You can set email column as unique constraint.

Integer primary key is better when you refer to email address in different table. If address itself is a primary key then in another table you have to use it as a key. So you store email addresses multiple time.

If user updates their email address then you have to update the email in each table you referred.

Refer below link for more details.

https://stackoverflow.com/questions/3804108/use-email-address-as-primary-key