python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - natural-key

Is it possible to have a natural and surrogate multicolumn primary key?

I have a temporal table that uses a natural primary key. This table stores a CSV file that was imported, it's a history table to keep track of every import. I starting to see some duplicates (in the C...
test-img

Daniel

sql-server

tsql

primary-key

surrogate-key

natural-key

Votes: 0

Answers: 1

Latest Answer

First, yes, you choose what the PK includes, so you can have it include both a natural and a surrogate key. This part of your thought is strange to me: "auto-incrementing key that only increments...
test-img

George Menoutis

Posts

Questions

Blogs

Jobs