title: Add DEFAULT constraint with a generated name
body: <p>In SQL Server I have an existing table. Now I want to add a DEFAULT constraint to one of the columns - <strong>without having to define a name for it</strong>.</p>
  
  <pre><code>-- generated name works fine when creating new column
  ALTER TABLE [xyz]
  ADD [newColumn] int NOT NULL DEFAULT 0
  
  -- when adding a default value afterwards I seem to have to provide a name
  ALTER TABLE [xyz]
  ADD CONSTRAINT [iDontWantToPutANameHere] DEFAULT 0 FOR [existingColumn]
  </code></pre>