title: Simple Syntax: Multiple Constraints in Alter Table Statement
body: <p>If I have this statement:</p>
  
  <pre><code>ALTER TABLE RecipeBox.Recipe ADD CONSTRAINT AKRecipeBox_Recipe_Name 
  UNIQUE NONCLUSTERED (Name)
  </code></pre>
  
  <p>How do I add another constraint to this statement? Is this even possible?</p>
  
  <p>Thanks</p>
  
  <p>Using SQL SERVER 2008 Developer Edition</p>