title: Deleting a SQL row ignoring all foreign keys and constraints
body: <p>I have a row in a table. This row has an ID column referenced in a few other tables with millions of rows. The SQL statement to delete the row always times out. From my design, I know the row I wish to delete is never referenced any where else. Hence I would like SQL to ignore having to check all other tables for a foreign key reference to this row and delete the row immediately. Is there a quick way to do this in SQL 2008?
  Perhaps something along the lines of:</p>
  
  <pre><code>DELETE FROM myTable where myTable.ID = 6850 IGNORE CONSTRAINTS
  </code></pre>
  
  <p>Or something along those lines.</p>