Using GUID as Primary Key

Can we use a GUID column as a primary key in a table?

Yes.

GUID can be used as a Primay key but it's having some drawbacks like :

(1) They are large(16 bytes) that is they will consume more space .
(2) Even performance and storage implications are present in this.
(3) They do not sort well as they are essentially random numbers.
(4) They are hard to remember as well as hard to debug.
(5) They can make URL's harder to read.

Do refer this link : https://blog.codinghorror.com/primar...-versus-guids/

Quote:

---

Originally Posted by Sherin Mathew

GUID can be used as a Primay key but it's having some drawbacks like :

(1) They are large(16 bytes) that is they will consume more space .
(2) Even performance and storage implications are present in this.
(3) They do not sort well as they are essentially random numbers.
(4) They are hard to remember as well as hard to debug.
(5) They can make URL's harder to read.

Do refer this link : https://blog.codinghorror.com/primar...-versus-guids/

---

Dated info. Those are largely problems of the past, at least on newer versions of SQL Server anyway.