Skip to main content
Database Administrators

Return to Answer

added 92 characters in body
Source Link
Ross Bush
Ross Bush
  • 629
  • 1
  • 5
  • 18

Give it a PK. This helps in multiple aspects of data management, not just logical.

For example, suppose at some point later you decided to ship this data somewhere and whatever gatekeeper requires and checks that your table has a PK (does not know it is IDENTITY), you would have to scramble and that is not fun.

Also, in the replication world heaps are not fun, whether using MS tools or some others.

Give it a PK. This helps in multiple aspects of data management, not just logical.

For example, suppose at some point later you decided to ship this data somewhere and whatever gatekeeper requires and checks that your table has a PK, you would have to scramble and that is not fun.

Give it a PK. This helps in multiple aspects of data management, not just logical.

For example, suppose at some point later you decided to ship this data somewhere and whatever gatekeeper requires and checks that your table has a PK (does not know it is IDENTITY), you would have to scramble and that is not fun.

Also, in the replication world heaps are not fun, whether using MS tools or some others.

Source Link
Ross Bush
Ross Bush
  • 629
  • 1
  • 5
  • 18

Give it a PK. This helps in multiple aspects of data management, not just logical.

For example, suppose at some point later you decided to ship this data somewhere and whatever gatekeeper requires and checks that your table has a PK, you would have to scramble and that is not fun.