Negative Primary Keys
Posted
by bjax
on Stack Overflow
See other posts from Stack Overflow
or by bjax
Published on 2010-03-18T20:41:14Z
Indexed on
2010/03/18
20:51 UTC
Read the original article
Hit count: 289
sql
|primary-key
Are there any repercussions using Negative Primary Keys for tables (Identity Increment -1, Identity Seed -1 in SQL Server 2005)?
The reason for this is we're creating a new database to replace an existing one. There are similar tables between the two databases and we'd like the "source" of the information to be transparent to our applications. The approach is to create views that unions tables from both databases. Negative PKs ensures the identities don't overlap.
© Stack Overflow or respective owner