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

Filed under:
|

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

Related posts about sql

Related posts about primary-key