Tag: surrogate-key

Found 12 results for 'surrogate-key'.

---

1) database-design - Should every table have a single-field surrogate/artificial primary key?
2) database-design - Should a inherited table have a new surrogate key, or just use parent table's key?
3) postgresql - Surrogate key resolution, or what am I missing in the Surrogate v Natural argument?
4) database-design - Composite primary key plus a separate (surrogate) id column for foreign key references
5) database-design - Should every table have a single-field surrogate/artificial primary key?
6) sql-server - Surrogate keys as Foreign Keys
7) normalization - What normal form does a surrogate key violate?
8) database-design - Foreign keys - link using surrogate or natural key?
9) foreign-key - How to get the "best of both worlds" with natural and surrogate keys? And could DBMSs be better?
10) postgresql - Reassigning surrogate keys?
11) postgresql - PostgreSQL surrogate keys: use sequence/bigint or OID?
12) sql-server - Do natural keys provide higher or lower performance in SQL Server than surrogate integer keys?

---