I just had the most surreal email discussion I think I've ever had...

I spent over two hours going back-and-forth over email with an enterprise DBA, trying to convince them I needed a primary key for a table. They created the table without a primary key (or any unique constraints... or indexes... but that's another discussion). I asked them to add one. Then had to justify why.

If you ever find yourself justifying why you need a primary key on a table in an RDBMS, that's the day you find yourself asking "is this real life?"

I want the last two hours of my life back. And a handful of Advil.

  • 5
    be glad that you didn't have to actually filter all the data in that table & remove duplicates

    i know people who had to do that for 100+ tables and ended up creating a new DB which PKs and everything and manually sorted everything
Add Comment