Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Guid as PK
Message
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
Guid as PK
Miscellaneous
Thread ID:
01455992
Message ID:
01455992
Views:
128
Kevin,


Beginners question...


Are there any serious drawbacks to using a guid as a pk that you know of ?

While we may get away with an int for most tables, there's one that may grow very large - if the business is successful

I am thinking of making the pk of all tables guid

I also want to add the possibility that someone can store a subset of the database onto his laptop, work on it, and later sync it back to the db

Your opinion ?
Gregory
Next
Reply
Map
View

Click here to load this message in the networking platform