By David Fekke
January 17th, 2011
I recently heard about a company that because they deleted what they thought was lookup data in a table ran into all kinds of relational issues with data in other tables that referenced that lookup table. On top of that it was a production database.
With very few exceptions, don't delete data from databases. SQL makes it very easy, maybe too easy to delete data from tables;