title: SQL remove autonamed constraints
body: <p>I have created a few constraints on my table with a script without specifying the constraint name. As a result, I ended up having constraints like <code>FK__DOC_OBGS___kntr___54E63309</code> for example. </p>
  
  <p>Is it possible to drop that constraints without specifying the exact constraint name ?</p>
  
  <p>For example, something like this (which doesn't work)</p>
  
  <pre><code>ALTER TABLE DOC_OBGS_10 DROP CONSTRAINT LIKE 'FK__DOC_OBGS___kntr%'
  </code></pre>
  
  <p>The problem is that we have a lot of databases with this table and I need to remove all the constraints from the tables, but apparently the name is different for each table. </p>