title: Is SQL Server Management Studio as bad as it seems? How to view relatiosnip attributes?
body: <p>So, I'm using SQL Server Management Studio Express,it has been working not bad so far, ignoring some of the weirdness.  </p>
  
  <p>But I just happened to get a whole shwack of data deleted when I happened to delete a row in a parent table.  So I thought I must have cascade deletes enabled in this relationship.  But, how does one determine this??  If you double click a relationship in the DB Diagram, your only option is Delete, and the tooltip only shows you the FK relationship name.</p>
  
  <p>This fellow had the same problem as me:
  <a href="http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/1f9c1e8f-b719-476d-828e-91ac6722096a/" rel="nofollow noreferrer">http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/1f9c1e8f-b719-476d-828e-91ac6722096a/</a></p>
  
  <p>So, am I missing something, or is this another situation where a software company deliberately does a half assed job?  I have an MSDN ultra (or whatever the highest level is) license, so will that be better, or, is there a 3rd party tool one can use??</p>