Using GUID as Primary Key

[ishan_shah]

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

[VictorN]

Yes.

[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/

[Arjay]

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.