Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bigint vs char(10) column decision
Message
From
18/05/2021 13:00:51
 
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
01680563
Message ID:
01680565
Views:
36
Is this a surrogate key? (i.e. system-assigned, no meaning, tied to another business identifier)

If it's a surrogate primary key, I'd ask someone to make a compelling argument on why a char(10) is needed. The answer of, "the other tables use char(10)'" doesn't cut it (at least not for me personally)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform