Quote:
Originally Posted by DBNull
Well I know what you saying but, architecture of the database is in place for a reason but its to in depth to really say why.
|
You are already talking about modifying the architecture if you are considering adding a secondary surrogate key.
You asked for opinions, and the general consensus is that what you have is a bad design, and what you are planning to do is also a bad design.